I've been looking on these forums for a while and have noticed most people are using JOINs in their SQL rather than than just a plain WHERE statement such as:
Code SQL:SELECT t1.* FROM t1, t2 WHERE t1.primary_key = t2.foreign_key
I've always used this for simplicity as I'm rarely doing anything too complicated and as I'm self taught if something works I tend to stick with it.
Are there any reasons I should be using JOINs over, if they're best practice then why. I'm thinking more practical reasons such as speed/memory use/etc rather than more theoretical reasons.