Thanks for your clean solution. Sometimes, we look for hard answers to simple questions instead of keeping it simple.
>The neat thing about SQL is that there can be multiple solutions:
>
>
>SELECT * FROM Invoice WHERE invoiceID IN (
> SELECT invoiceID FROM invoiceLineItems GROUP BY invoiceID HAVING COUNT(*) >=3)
>AND invoiceID NOT IN (
> SELECT invoiceID FROM invoicePayments)
>
>
>-Mike
It's "my" world. You're just living in it.
