shonir Posted August 12, 2011 Share Posted August 12, 2011 i just want to show that record not existing table {tbl}mailtemp 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 Link to comment https://forums.phpfreaks.com/topic/244579-whats-wrong-in-join-tables/ Share on other sites More sharing options...
chintansshah Posted August 12, 2011 Share Posted August 12, 2011 Please explain problem in detail. Link to comment https://forums.phpfreaks.com/topic/244579-whats-wrong-in-join-tables/#findComment-1256321 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.