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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxx | > ORA-03113: end-of-file on communication channel > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
