n8w Posted March 17, 2006 Share Posted March 17, 2006 I don't think this is a join but I'm not sure how to write it.I need help writing this sql statementI have two similar tablesarticlesaudio_articlesI want to return all the records from both tables wherearticles - return the field (article_id) where ( feature=t and live_date>today )audio_articles (id) AS article_id where ( s_front=t and s_date>today ) Quote Link to comment https://forums.phpfreaks.com/topic/5140-solved-help-please-sql-statement/ Share on other sites More sharing options...
Barand Posted March 17, 2006 Share Posted March 17, 2006 Sounds like you need a UNION[code]SELECT article_id FROM articles WHERE ( feature='t' AND live_date>CURDATE() )UNIONSELECT id AS article_id FROM audio_articles WHERE ( s_front='t' and s_date>CURDATE())[/code] Quote Link to comment https://forums.phpfreaks.com/topic/5140-solved-help-please-sql-statement/#findComment-18288 Share on other sites More sharing options...
n8w Posted March 17, 2006 Author Share Posted March 17, 2006 [!--quoteo(post=355866:date=Mar 17 2006, 04:51 AM:name=Barand)--][div class=\'quotetop\']QUOTE(Barand @ Mar 17 2006, 04:51 AM) [snapback]355866[/snapback][/div][div class=\'quotemain\'][!--quotec--]Sounds like you need a UNION[code]SELECT article_id FROM articles WHERE ( feature='t' AND live_date>CURDATE() )UNIONSELECT id AS article_id FROM audio_articles WHERE ( s_front='t' and s_date>CURDATE())[/code][/quote]Hey Barand .. you are awesome! thanks! Quote Link to comment https://forums.phpfreaks.com/topic/5140-solved-help-please-sql-statement/#findComment-18329 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.