I'm having trouble puting up a query in Mysql because of his lack of SQL
syntax.
I have a table A and a table B... I want all occurences from A there are
not in B...
in ANSI SQL... it's nothing more than:
select a.id, a.name from table_a a, table_b b where a.id NOT IN (select id
from table_b)
and that's it... but in Mysql, since there are no sub-selects, I'm burning
my brains out and not getting it... I don't wanna create a temp table like
the manual suggests... this is way NOT efficient... I'd rather do it in PHP
code than having a query that creates a temporary table, then drop it...
_____________________________
. Christian Dechery
. . Gaita-L Owner / Web Developer
. . http://www.webstyle.com.br
. . http://www.tanamesa.com.br
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
