Re: JOIN problem
| From: | Simon Rees | Date: | Mon, 07 Feb 2005 19:47:08 +0000 |
| Subject: | Re: JOIN problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-38506@lists.php.net to get a copy of this message | ||
On Monday 07 February 2005 18:22, Zouari Fourat wrote:
> Hello
> I have 2 tables with two columns in each one (cloned tables) like this :
>
> ID int(6)
> UserName varchar(25)
>
> and i would like to select usernames from table1 that doesnt appear in
> table2 so i did this :
Depending on which database you're using you may be able to do this:
SELECT a.username
FROM table1 a
WHERE a.username NOT IN ( SELECT b.username FROM table2 b )
cheers Simon
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Simon Rees | tech-lists@zodiac2000.co.uk |
ORA-03113: end-of-file on communication channel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~