Multi Column Sub Query Support - by Imran Shaikh

Status : 


Sign in
to vote
ID 288772 Comments
Status Active Workarounds
Type Suggestion Repros 2
Opened 7/23/2007 10:47:33 PM
Access Restriction Public
Primary Feedback Item 299231


Still there is no support for multicolumn sub queries....

e.g. in oracle....

Select * from CallDetails where (CustomerID, ProductID) IN (Select CustomerID, ProductID from CustomerGroups Where GroupID=1)

I was in big trouble when converting queries of oracle financials when I was creating Reporting Server on SQL2005, in Oracle Financials it doesnt have one column primary keys.... almost in all the tables multicolumn primary keys.... same scenario i need to handle when developing ETL and Reporting Layer for Convergys.... Geneva Billing System....

Scenario is difficult when joining 10...15 tables to retrieve data and almost 3...5 of them needs a sub query support with multi column sub queries... it takes a lot of time to convert.....

Sign in to post a comment.
Posted by Microsoft on 3/23/2010 at 2:03 PM
I have resolved this feedback item as duplicate of one below:

Umachandar, SQL Programmability Team
Posted by Erland Sommarskog on 8/18/2008 at 3:10 PM
Note that the query could be written as

SELECT * FROM CallDeatils CD
                             FROM    CustomerGroups CG
                             WHERE CG.CustomerID = CD.CustomerID
                                 AND CG.ProductID = CD.ProductID)

There are other situations where the need for row constructors is more compelling, though.
Posted by Microsoft on 12/14/2007 at 4:56 PM
Thanks for your feedback. We are looking into adding such functionality in a future release. Until then a work around to rewrite the query explictly to use a join syntax is recommended.

Best regards