Hi All,

i have tow table soldlots and clientinf i need to get the ID from clientinf if the same ID is not exits in soldlots. I tried following query but it is not returning correct result.

for the example the id_lot have 3 id_client and one is already in soldlots but when i run the following query it is displying whole 3 records, it must display only two and ignore the one which already have duplicate in soldlots.

select clientinf.id_client as cids from clientinf left join soldlots on clientinf.id_client != clientinf.id_client
where clientinf.id_lot = 44


Pls advise me how i can make the correct query.

Hi,

Thank You very much it is working good.

Appreciating for your help.