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