Let’s say I want to get a list of client Names, and a count of their invoices via SQL in 4D.
I think I should be able to do this:
( SELECT COUNT (*) FROM Invoices where Invoices.Client_ID = Client.id)
But this doesn’t work.
What’s the proper sql to do this?