Jump to content

Archived

This topic is now archived and is closed to further replies.

n8w

**SOLVED** help please .. sql statement

Recommended Posts

I don't think this is a join but I'm not sure how to write it.
I need help writing this sql statement

I have two similar tables
articles
audio_articles

I want to return all the records from both tables where
articles - 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 )

Share this post


Link to post
Share on other sites
Sounds like you need a UNION

[code]SELECT article_id FROM articles  WHERE ( feature='t' AND live_date>CURDATE() )
UNION
SELECT  id AS article_id FROM audio_articles WHERE ( s_front='t' and s_date>CURDATE())[/code]

Share this post


Link to post
Share on other sites
[!--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() )
UNION
SELECT  id AS article_id FROM audio_articles WHERE ( s_front='t' and s_date>CURDATE())[/code]
[/quote]

Hey Barand .. you are awesome! thanks!

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.