Querying multiple mySQL tables simultaneously

Question

Hi guys, as the title states, I am trying to query multiple mySQL tables in the same DB simultaneously, here is my query,

SELECT * FROM `database_db`.`one, two, three, four, five, six, seven` WHERE uid='1234567'

I am using mySQL workbench to do the query, but when I run it I get this error

Error Code: 1103
Incorrect table name 'one, two, three, four, five, six, seven'

I know that the problem lies with my query, where I select the tables, I am assuming that I cannot select more than one, or maybe my syntax is incorrect?

Is there another way for me to achieve the same result?

EDIT: Each table is different, each has a different amount of columns, the only thing they have in common is the uid.

For instance, table one has the columns "oneA, oneB, oneC" and table two has the columns "twoA, twoB, twoC, twoD, twoE", and so on and so forth for each table, as you can see they do not have the same amount of columns, and are in no way identical to each other.

Thanx in advance.

Answer 1

IF table structure is identical for tables: one, two, three ... then you can use UNION

SELECT * FROM one
WHERE uid='1234567'
UNION ALL
SELECT * FROM two
WHERE uid='1234567'
UNION ALL
SELECT * FROM three
WHERE uid='1234567'
....
UNION ALL
SELECT * FROM seven
WHERE uid='1234567'

Answer 2

You probably want to JOIN the tables:

SELECT *
FROM one
JOIN two ON one.uid = two.uid
JOIN three ON one.uid = three.uid
WHERE one.uid='1234567'

Answer 3

Maybe I don't understand the question very well but what about something like this:

SELECT *  
  FROM table_a a, table_b b, table_c c 
 WHERE a.uid = b.uid = c.uid = 12345;