Is it possible to use sub query in joints

Answer 1

yes it is possible but try to avoid sub query.it increase execution time.

Answer 2

Yes you can

Answer 3

yes

Answer 4

yes

Answer 5

using a subquery, will use up ur processing time...so avoid using subqueries

Answer 6

joins is similar to subqueries
joins save time and energy and it's easier to understand and use
you will have less error chances in joins

Answer 7

yes

Answer 8

sim

Answer 9

yes you can use it

Answer 10

yes..it is..!! better use stored procedure!!