But I want something like this where only null values are returned

select cc.cc_clientcode,cc.cc_rmcode,cc.cc_panno,cc.cc_productname

,c.Client_panno,c.client_userid

--,u.user_userid

from clientcode cc LEFT outer join client c

on cc.cc_panno=c.client_panno order by cc_clientcode

where c.client_panno is null