ITPub博客

 select account,displayname,password,ex_22222.exattribute3 from (select * from ut_users u where not exists (select *  from ut_users1 u1 where u1.account = u.account and u1.password = u.password)) newtable,ex_22222 where newtable."UID" = ex_22222.entityid