mysql union help

[c_pattle]

I have the follow sql which uses "union" to combine to select statements.  However when I run this it gives me all of the results of the first statement follow by all of the results of the second statement.  I was wondering if there is a way to make it output 1 results from the first statement then one results from the second statement then the second results from the first statement etc

 

SELECT * FROM articles WHERE article_verification="1" limit 0,10 UNION (SELECT * FROM announcements WHERE announcement_verification="1" limit 0, 10);

 

Thanks for any help. 

[c_pattle]

Actually sorry forget that.  What I want to do is to have a mysql query that will combine a row from two tables into one.  For example say I have the follow tables,

 

articles:

1 - article 1

2 - article 2

3 - article 3

 

announcements:

1 - announcement 1

2 - announcement 2

3 - announcement 3

4 - announcement 4

 

What I want to do is to have a statement that will return the first row of both tables.  I think the best thing to do is a select statement but mine isn't quite working right. 

 

select articles.article_title, announcements.announcement_title from articles, announcements order by article_number desc limit 0,10

[Muddy_Funster]

If you want the article and announcement to match up with each other you will need to join them on a common field type.

 

A sample dataset and your table structues would be a big help to us.