Solution found!!!

SELECT C.clientid, T.charge_type

FROM Clients AS C

CROSS JOIN ChargeCategories AS T

EXCEPT

SELECT clientid, charge_type

FROM Charges;

This is an old system and I have no control over the existing tables, I cannot ask for changes to the procedures that import that data. What we are trying...

Lutz,

Just what the Dr ordered...!

Thanks,

Vicar

One record in the Batches table (Header values), one record in the Clients table (Record values - this data happens to contain only one client) and six records in the...

Lutz,

My project is not realy for agriculture but its nature prohibits me from using anything that resembles its type so I have made many changes to the original values in...