I have three tables A (Master), B (Master) and C (Transaction).
The combination of A.id and B.id exists in C.
I want that data of A where combination of A.id and B.id do not exist in table C.

I tried the following but get no rows selected.

SELECT A.\* from A, B, C where A.id != C.id and B.id != C.id

I am not that good at creating queries.

Can someone please form a query for this?