I want to improve my queries knowledge lz suggest me wot i do...


Wot is the difference between using joins to get data from more than one tables and using subqueries to do same. when to use what.
i'll b thankful to whom reply

when you need to retrive the data from more than one columns of multiple tables then use joins.otherwise use subquery.if you want improve the query knoladge then use books online and start practicing the example given there.

Basically using subquery than joins mostly results in performance degradation, however using subqueries for smaller tables is fine while for larger tables go for joins (because subqueries may introduce internal worktables which is an extra overhead) !

Harsh Athalye
India
"Nothing is impossible"