>>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?

John,

I have no idea, this wasn't my problem it was someone else's