Hi, I have a table B which is connected to table A through a integer foreign key. This is a 1:1 relation so for every item in table B there is exactly one item in table A.
But not every item in A must have a connection to B. I stored the foreign key in table B and using it as a primary key (that was the easiest way to ensure that there is only one item in B for every item in A). No I want to get all items from table A where no matching item in table B exists. I'm aware that this would be very easy if table A stores the foreign key. I think there is no direct sql query which can do that for me, right? So I have to query for every item in table A that there is no matching item in B? (I just want to make sure that I'm not missing a really obvious optimization.) Thanks so far, fs
smime.p7s
Description: S/MIME Cryptographic Signature
