|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
|
|
#1
June 22nd, 2009, 12:53 PM
|
|||
|
|||
|
SQL - Using Except Or Minus, Finding the Difference between 2 tables
Hi,
I'm struggling to find a way to find the difference between two tables...here is my query...any advice? SELECT ingredient_id, ingredient_name FROM ingredients EXCEPT SELECT ig.ingredient_id, ig.ingredient_name FROM ingredients AS ig INNER JOIN pantry AS pa ON ig.ingredient_id = pa.ingredient_id WHERE pa.customer_id = 1
|
|
#2
July 1st, 2009, 08:59 AM
|
||||
|
||||
|
What RDBMS are you using?
If I am understanding what you are asking for - look into OUTER JOIN
__________________
life is a game.... Have fun ----------------------------- http://www.phpwomen.org strength in unity PHPCommunity IRC #phpc on freenode
|
|
#3
October 19th, 2009, 01:16 AM
|
|||
|
|||
|
Re:Using Except Or Minus, Finding the Difference between 2 tables
Hi,
why don't you use 'not in' the below query SELECT ingredient_id, ingredient_name FROM ingredients where ingredient_id not in (SELECT ig.ingredient_id FROM ingredients AS ig INNER JOIN pantry AS pa ON ig.ingredient_id = pa.ingredient_id WHERE pa.customer_id = 1) I hope that above query will be very useful for you. Thanks & Regards Sakthimeenakshi.S ---------------------------------------------------
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > SQL - Using Except Or Minus, Finding the Difference between 2 tables |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
