|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today! |
|
#1
December 6th, 2002, 05:39 PM
|
|||
|
|||
|
Query: Subtraction one set from another set in MySQL
Hi,
Does anyone know in MySQL, how to exclude one set of record from another set, which is similar to 'NOT IN' in some SQL language. e.g: select * from A where A.ID NOT IN ( select ID from Table B ) Thanks a lot. Roger
|
|
#2
December 7th, 2002, 04:29 PM
|
|||
|
|||
|
RE: Query: Subtraction one set from another set in MySQL
SELECT * FROM table1 WHERE id NOT IN (SELECT id FROM table2);
is equal to: SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id WHERE table2.id IS NULL;
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Query: Subtraction one set from another set in MySQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
