Is hope someone can help me.
I have 3 tables (A,B,C)
In Table A there are 2 columns (A.Pkey and A.Name)
In Table B there are 2 columns (B.ID1 and B.ID2) A.Pkey and B.ID1 contains the same unique values
In Table C there are 2 columns (C.ID3 and C.Value) B.ID2 and C.ID3 contains the same unique values (if exists)
I'm searching for the right query for listing all the names where there is NO record in tables C
Thanks in advance
I have 3 tables (A,B,C)
In Table A there are 2 columns (A.Pkey and A.Name)
In Table B there are 2 columns (B.ID1 and B.ID2) A.Pkey and B.ID1 contains the same unique values
In Table C there are 2 columns (C.ID3 and C.Value) B.ID2 and C.ID3 contains the same unique values (if exists)
I'm searching for the right query for listing all the names where there is NO record in tables C
Thanks in advance