Re: Multi-table query in one select - possible?

2003-08-25 Thread Roger Baklund
* Mike Morton > Runnint Mysql 3.23.47 > > I have the following two tables: > backorder_notification > ->product_code varchar > ->email varchar > ->date_added date > Products > ->code varchar > ->name varchar > ->other stuff that is not important > > Essencially - I want t

Multi-table query in one select - possible?

2003-08-25 Thread Mike Morton
Runnint Mysql 3.23.47 I have the following two tables: backorder_notification ->product_code varchar ->email varchar ->date_added date Products ->code varchar ->name varchar ->other stuff that is not important Essencially - I want to get a count of the product codes that a