Don't use subselect in MySQL, MYSQL have not completed it now , Use "join"
to instead it.
"Christian Dechery" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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]