I have a basic invoice table with related line items table
Goal : I'd like to get ALL the related line items - for ALL the
'open' invoices...
-- this should get a list of open (unpaid) invoices
$query_invoice = "SELECT DISTINCT ID from invoices where status =
'open'"
-------------
-- then I'd like to get ALL the line items - in ALL these 'open'
invoices - so how do I write the next SQL statement :
$query_items = ??? "SELECT ID, NAME from lineitems where --xx???
xx--" ???
Thanks,
c...@hosting4days.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org