Rows from 2 tables together

Hi,

I'm trying to get rows out of two tables and list them together. Using MySQL (and PHP)

It must be all Mysql. I tried getting the rows seperately and merging the arrays with PHP bu I can't then to pagination.

Here's what's in the tables:

Table 1:

id - name
----------
1 Mary
2 Robert
3 Chris


Table 2:

id - name
----------
1 John
2 Dave
3 Mike


So I want the SQL statement to return the following (in any order):


1 Mary
2 Robert
3 Chris
4 John
5 Dave
6 Mike


Thanks!

 

SELECT * FROM table1 UNION SELECT * FROM table2

 

Thanks.
I've resolved it a different way though.

I simply created pagination for the array of data (the array merged from 2 different SQL calls). Works like a charm!

Thanks anyway!