SELECT productid, productname, unitprice FROM Production.Products WHERE supplierid IN (SELECT supplierid FROM Production.Suppliers WHERE country = N'Japan');
- 4. Combining Sets
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Using a subquery for the IN predicate to generate a single column list, like generating a list of record codes where a record name is like X.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/24098/