one more mysql question
| From: | afan@afan.net | Date: | Fri, 12 Aug 2005 21:33:49 +0000 |
| Subject: | one more mysql question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-220531@lists.php.net to get a copy of this message | ||
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?
Thanks for any help.
-afan