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 | +-------------+------------+-----------+ | VAL1 | VAL2 | VAL3 | +-------------+------------+-----------+ But what I want is: +-------------+ | data | +-------------+ | VAL1 | | VAL2 | | VAL3 | +-------------+ Is this possible? BTW, I'm using MySQL 3.23.35 Thanks, Eric --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php