|
|
Posted by Philip Hallstrom on 08/13/05 00:52
> 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
Navigation:
[Reply to this message]
|