sql join question [message #4360] |
Mon, 02 December 2002 17:55 |
ravi_kiran99
Messages: 8 Registered: December 2002
|
Junior Member |
|
|
Hi,
I need help with a sql (self join) query. Thanks for all your help.
A table T1 has columns C1,C2,C3
I want to perform a query to get all the rows where value of C2 is equal to someother value of C2 in the same table in a different row and C3='N'
C1 C2 C3
sam 100 Y
tom 200 N
john 300 N
sam 100 N
I want to be able to select the 4th row from the above data because for this row (value of C2 is same as value of C2 in the first row and C3=N )
|
|
|
|