Re: UPDATE: I've tried "UNION SELECT" and it's getting warmer

[Barry Galbraith]

Show us the tables you are trying to get data from.

mysql>SHOW CREATE table1 \G
mysql>SHOW CREATE table2 \G  &c

Some INSERTs for some representative data.

The query you are trying to run.

The way you want the output to be.

Put all your code between [ code ] and [ /code ] tags (without the spaces in the tags)

Good luck,
Barry.