Query on two tables at once

aspect

Hi another dumbass quation for you Gurus to laugh at... 🙂

How do i query two tables in the same statemnt ?

eg.
I have two tables called "news" and "news_archive"
both tables have almost the same fields but the different fileds are of no relevance for this query.

One of the fields is "date" and i I want to pull out the latest 20 records from either from the conbined databases results if that makes sense.....

Hope someone get my meaning... 🙂

Look forward to any help..

Thanks

Ian

sneakyimp

if news and news_archive have nothing to do with each other, then you should run two queries.

if you are concerned about sorting the articles in order by date, then you are going to need to merge the two datasets once you get data back from php....then you can sort them using php functions like arsort() or sort().

at least i think so anyway.

aspect

Let me try and explain my challenge a little more.

I am showing only the latest 20 records so i have been using

SELECT * FROM news ORDER BY date DESC LIMIT 20

Forgive the messed up syntax but i wanna do something like this.

SELECT * FROM news AND news_archive, ORDER BY date DESC LIMIT 20

I dont think this syntax is correct, but hopefully someone will get my drift.. 🙂

sneakyimp

as i was saying, i don't think you can do that.

Roger_Ramjet

You can, with a UNION QUERY . You will be limited by the fact that each select must return the same number and types of fields, but there rae ways around that.

To sort on the whole resultset you have to enclose each select in barckets, then you can apply sorting and limits.