>Dennis,
>
>Make the join to Invdetail a LEFT OUTER instead of INNER. This is because you want all invoices regardless to whether they have details or not (A LEFT OUTER JOIN)

Just curious, how can you have an invoice with no detail? Or why would you?