Select from one table where ID not in another table

2003-09-02 Thread Martin Moss
All, Am wondering if it's possible to do a query that does something like this:- SELECT table1.*,table2.id from Table1 AS table1,Table2 AS table2 WHERE table1.id DOESN'T EXIST IN table2.id; Regards Marty --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system

Select from one table where ID not in another table

2003-09-02 Thread Martin Moss
All, Am wondering if it's possible to do a query that does something like this:- SELECT table1.*,table2.id from Table1 AS table1,Table2 AS table2 WHERE table1.id DOESN'T EXIST IN table2.id; Regards Marty --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system

RE: Select from one table where ID not in another table

2003-09-02 Thread Dathan Vance Pattishall
from one table where ID not in another table -- --All, -- --Am wondering if it's possible to do a query that does something like --this:- -- --SELECT table1.*,table2.id from Table1 AS table1,Table2 AS table2 --WHERE table1.id DOESN'T EXIST IN table2.id; -- -- --Regards -- --Marty

Re: Select from one table where ID not in another table

2003-09-02 Thread Martin Moss
to get table1.* Regards Marty - Original Message - From: Martin Moss [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 9:49 PM Subject: Select from one table where ID not in another table All, Am wondering if it's possible to do a query that does something

Re: Select from one table where ID not in another table

2003-09-02 Thread Martin Moss
to get table1.* Regards Marty - Original Message - From: Martin Moss [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 9:49 PM Subject: Select from one table where ID not in another table All, Am wondering if it's possible to do a query that does something

Re: Select from one table where ID not in another table

2003-09-02 Thread Kelley Lingerfelt
select t1.* from table1 t1 LEFT JOIN table2 t2 on t1.id=t2.id WHERE t2.id IS NULL you can print out table2 values if you want, but they will all be NULL.. provided that table2.id and table1.id are the matches you are trying to find. Kelley Martin Moss wrote: All, Am wondering if it's

Re: Select from one table where ID not in another table

2003-09-02 Thread Matt W
[EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 3:54 PM Subject: Select from one table where ID not in another table All, Am wondering if it's possible to do a query that does something like this:- SELECT table1.*,table2.id from Table1 AS table1,Table2 AS table2 WHERE

Re: Select from one table where ID not in another table

2003-09-02 Thread Martin Moss
[EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 10:27 PM Subject: RE: Select from one table where ID not in another table Well, in order for that to work, you will need to do an explicit JOIN somewhere or else the IS NULL or NOT NULL won't work. You might try... SELECT table1.*, table2.id

Re: Select from one table where ID not in another table

2003-09-02 Thread Kelley Lingerfelt
] Sent: Tuesday, September 02, 2003 10:27 PM Subject: RE: Select from one table where ID not in another table Well, in order for that to work, you will need to do an explicit JOIN somewhere or else the IS NULL or NOT NULL won't work. You might try... SELECT table1.*, table2.id FROM table1

Re: Select from one table where ID not in another table - Solved

2003-09-02 Thread Martin Moss
- From: Martin Moss [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 10:47 PM Subject: Re: Select from one table where ID not in another table I'm not sure if I've described the exact results I want very well, but thanks to everyone for your help so far, hope you