one more mysql question

["afan@xxxxxxxx" <afan@xxxxxxxx>]

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

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