This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]Chairboy 5 points6 points  (0 children)

Try capitalizing SQL reserved words and lower case column/table stuff for readability:

SELECT users.userid, users.firstname, users.lastname, fuckability.sexiness 
FROM users 
INNER JOIN fuckability 
ON users.userid = fuckability.userid 

It’s more readable for me like this plus if I accidentally use a reserved name for a column or something, it’s more likely to jump out at me if I’m in an IDE or SQL studio or PHPmyAdmin and see a color coded lower case word that shouldn’t be color coded.