Question Regarding Subquery

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

0

Hi,

Its better to use JOINs instead of SUB QUERIES.

0

--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

Example

Create Proc Pro_Test

as

begin

Select ProductName,

(select categoryname from tbl_ProductCategory where categoryID=P.CategoryID)

as CategoryName from tbl_Product P

end

0