SQL: Join vs. subquery

Posted by Col. Shrapnel on Stack Overflow See other posts from Stack Overflow or by Col. Shrapnel
Published on 2010-04-05T06:22:22Z Indexed on 2010/04/05 6:33 UTC
Read the original article Hit count: 358

Filed under:
|
|
|

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?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about sql