Re: one more mysql question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I tried this one:
SELECT trans_no
FROM orders
WHERE trans_no IN (
SELECT trans_no
FROM special_orders )

but gives me an error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT trans_no FROM special_orders )' at line 5

???


Philip Hallstrom wrote:

I apology for mysql question posted here, but, as I said once, I like you guys more! :)

have two tables: orders and special_orders. foreign key is trans_no.
I can't figure it out how to create a query that pulls orders from the "orders" tables that are NOT in "special_orders" table?


I can never remember the syntax, but you want to LEFT JOIN the tables and then only return rows where the resulting special_orders column is NULL.

something like this (most likely wrong syntax):

SELECT o.trans_no, s.trans_no FROM orders o LEFT JOIN special_orders s ON o.trans_no = s.trans_no WHERE s.trans_no IS NULL

But that should get you started...

-philip




--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux