Table cp has primary key cp.id. In Table su, su.pid is a foreign key pointing to cp.id. However, not every record in table cp necessarily has an entry in table su. That is what I am looking for-all records in cp that don't have an entry in table su. Can somebody help me with the sql for this requirement?
Thanks