: mysql@lists.mysql.com
> From: c...@hosting4days.com
> Subject: Basic SQL Query Help Needed
> Date: Tue, 25 Aug 2009 16:21:45 -0700
>
> 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
>
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'"
-
--