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
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
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
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
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
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
[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
[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
]
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
-
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
10 matches
Mail list logo