See example below if it's not clear what I'm looking to do:
Table 0 Table1 0 | A 5 | F 1 | B 6 | G 2 | C 7 | H 3 | D 4 | E
Combined table 0 | A 1 | B 2 | C 3 | D 4 | E 5 | F 6 | G 7 | H
I'm sure there's a simple way to do it but I'm not sure how.
Richard, try the UNION ALL operator, something like this:
SELECT a, b FROM t0 UNION ALL SELECT a, b FROM t1
-- Darren Duncan