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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.