Zouari Fourat wrote:
am using mysql 3 so i can't do that subquery, how can we do that in mysql 3 ?
and neither can anyone else ;-)... rather a pain, but mysql.com have been kind enough
to give a detailed explaination on how to rewrite subselect queries as join queries:
If you put your brain in gear this page should tell what you need to know:
http://dev.mysql.com/doc/mysql/en/rewriting-subqueries.html
If you get stuck, you know where the list is :-)
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
