You have two ways to do this
Select B.* FROM B
LEFT JOIN A ON A.ID = B.ID
LEFT JOIN C ON C.Column_name = B.Column_name
Where A.ID IS NULL
The Other is
Select B.* FRom B
LEFT JOIN C ON C.Column_name = B.Column_name
where B.ID NOT IN (SElect A.ID From A)
*Column_name means you need to give column name you are willing to do between B and C