Originally posted by ganga
On what scenario it is better to use JOINS over Sub queries?
Always, except when it doesn't matter.