|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Join statement help in MySQL?
I have a table with 2 coloumns-
Rec ID A 1 AB 1 A 2 A 3 A 4 AB 4 Now i want all those ID for rec A which is not in table for rec AB. I am using following query for the same- select ID from table where Rec='A' and ID not in (select ID from table where Rec='AB'); this sud give me result (2,3) Can you please help me to write same query using join statement because my sql version is not compatible with sub query. |
|
#2
|
|||
|
|||
|
oh i think it is difficult
----------------------------------------- buy dvds on cartoon77.com |
![]() |
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > Join statement help in MySQL? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|