Join Query Help

[eluser]TheFuzzy0ne[/eluser]
Please could you also show me the columns in your users table? I assume you have one.

You can safely remove the Username column from both tables, since that data will come from the users table, so long as we have a user ID. If you don't have one, you definitely should, otherwise you are duplicating data in your database, as if a user changed their username, you'd have to update the username columns in both the articles and comments tables, and any other tables where it was stored, which is messy.

You may have to wait for a working example (no more than a day), as I'm extremely busy at the moment.