i just want to show that record not existing table {tbl}mailtemp
[php]
select en.id as en_id, en.title as en_title, mt.id as mt_id, mt.subject from {tbl}noticelogs nl, {tbl}expiration_notice en right JOIN {tbl}mailtemp mt ON (en.type=mt.parentid)
where nl.noticeid<>en.id and nl.mailid<>mt.id
[/php]