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 | [EMAIL PROTECTED] | 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
