Jump to content

**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

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 )
Link to comment
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() )
SELECT  id AS article_id FROM audio_articles WHERE ( s_front='t' and s_date>CURDATE())[/code]

Hey Barand .. you are awesome! thanks!
Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

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.