Where exists

[#1]

Hi all.

Could some one help me with a, I guess easy, where exists expression. I have to tables (Address and Contract) that are linked together and the keyfield is AdressID. There is only 10% of the contracts that have a address, which is correct. But I don't want to load all the addresses just the ones that have a contract.

Thanks!

[Anonymous · Accepted solution]

Load

     fieldA,

     fieldB,

     etc.

From Address

where exists(AdressID, AdressID);

Just make sure you load the Contract table first so you have the AdressID field there to refer to already.