Alexander Farber wrote:delete from pref_userswhere id not in (select distinct id from pref_money);
Hi,
try insteaddelete from pref_userswhere id in (select id from pref_users except select id from pref_money);
RegardsWolfgang Hamann