Question Regarding Subquery

Question

Dear Frnds i want to use Sub Querie's in my stored Procedures. can any1 tell or show me how to make the Sub Queries(Syntax and example) and what are the points to remember while making a Subqueries. Please need your help. Thanks & Regards Aamir

Pankaj Rana · Answer

Yes you are right but this is example of subquery otherwise joins are better than subqueries.

Jaganathan Bantheswaran · Answer

Hi Its better to use JOINs instead of SUB QUERIES.

Pankaj Rana · Answer

--There are two tables tbl_ProductCategory and tbl_Product --In tbl_Product CategoryID is foregin key which is primary --key in tbl_ProductCategory --For subqueries there should be a refrence integrity( for more about data integrity visit: http://queriesinsql.blogspot.com/2011/12/data-integrity-in-database.html E xample Create Proc Pro_Test as begin Select ProductName (select categoryname from tbl_ProductCategory where categoryID=P.CategoryID) as CategoryName from tbl_Product P end