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 ) 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] 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! 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
Archived
This topic is now archived and is closed to further replies.