SELECT * FROM YourTable y
WHERE EXISTS
(
SELECT * FROM YourTable y1 WHERE y1.col1 = y.col1 AND y1.col3 = 'A'
)
AND EXISTS
(
SELECT * FROM YourTable y2 WHERE y2.col1 = y.col1 AND y2.col2 = 'B' and y2.col3 = 'A'
)
@ sunitabeck ****YOU SUCH GENIUS***** *****What a BEAUTIFUL ELEGANT SIMPLE solution!!!!!!***** I'm pondering it for many months but couldn't come up any good solution, but YOU.
How to use SQL to query this complex structure?
Posted - 11/05/2012 : 17:47:10
