SELECT A.*, B.Vendorname, SUM(C.Subtotal) AS InvoiceTotal
FROM Invoice A JOIN Vendor B ON A.VenID=B.VenID
JOIN LineItem C ON A.InvoiceID=C.InvoiceID
WHERE A.InvoiceID=1000
GROUP BY A.InvoiceID, A.VenID, A.InvDate, A.Closed
The "Closed" field above in the Invoice table is a bit field and in SQL7 I get "Cannot group by a bit column." error. How do I pull this off so it works? TIA.
It's "my" world. You're just living in it.