[prineside]

Quote:

Originally Posted by Vince The JOIN keyword is probably the most important keyword there is. If you do not known what this is or what it does then you're not ready to use SQL just yet.

Well, in particular, I almost never use JOIN keyword in my gamemode's queries. Most time I need just a few fields from foreign table so I use, for example, SELECT vehicle.*, account.login FROM vehicle, account WHERE vehicle.id = 12 AND vehicle.owner = account.id.

Of course you must know about JOIN before you start using SQL, but queries may be OK without it. I said this just because many people start doing exactly the same things they read from someone's comment (especially with high rep) and think that their queries are wrong because there's no JOIN in them.