how to select all the data from many tables?
Posted
by Syom
on Stack Overflow
See other posts from Stack Overflow
or by Syom
Published on 2010-03-26T15:43:46Z
Indexed on
2010/03/26
15:53 UTC
Read the original article
Hit count: 140
mysql
|phpmyadmin
how to select all the data from many tables? i try
`"SELECT * FROM `table1`, `table2`"`
,
but result none understandable for me. it returns only some rows from table1, and 3 times all the data from table2. i've red one same question here, but don't understand the answer. so could you help me? thanks in advance.
update:
when i try
(SELECT * FROM `videos`) UNION (SELECT * FROM `users`)
it returns #1222 - The used SELECT statements have a different number of columns
© Stack Overflow or respective owner
