Re: JOIN problem
| From: | Zouari Fourat | Date: | Tue, 08 Feb 2005 08:21:25 +0000 |
| Subject: | Re: JOIN problem | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-38508@lists.php.net to get a copy of this message | ||
am using mysql 3 so i can't do that subquery, how can we do that in mysql 3 ?
On Mon, 7 Feb 2005 19:47:08 +0000, Simon Rees
<tech-lists@zodiac2000.co.uk> wrote:
> 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
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>