Combine data from multiple tables

2002-01-11 Thread Eric Mayers
I have three tables, each with a single column, data. I'd like to form a query that will combine the table columns into a common result column. When I use the query: SELECT * from tab1, tab2, tab3 I get: +-++---+ | data| data | data |

RE: Combine data from multiple tables

2002-01-11 Thread Roger Baklund
* Eric Mayers I have three tables, each with a single column, data. I'd like to form a query that will combine the table columns into a common result column. When I use the query: SELECT * from tab1, tab2, tab3 I get: +-++---+ | data| data |