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: 144

Filed under:
|

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

Related posts about mysql

Related posts about phpmyadmin