sistkarthik
New Member
Consider this query:\[code\]SELECT table1.id, table1.review, table1.time, table2.author, table2.title FROM table1, table2 WHERE table1.id = table2.id AND table1.reviewer = '{$username}'ORDER BY table1.id\[/code\]I'm using the above quite a lot around my site's code. I find that adding the table prefixes etc. before the column names can make the query very long and take up quite a lot of lines.Is there a way to make the above query simpler/easier?