SQL: Join vs. subquery
- by Col. Shrapnel
I am an old-school MySQL user and always preferred JOIN over sub-query. But nowadays everyone uses sub-query and I hate it, dunno why.
Though I've lack of theoretical knowledge to judge myself if there are any difference.
Well, I am curious if sub-query as good as join and there is no thing to worry about?