How to make a sample of 5 tables with the same fields by condition in MySql?

There is a database with 5 tables and dikoviny fields.
id, tel, login, pass, type
You need to find the value of a field (tel) searching in all tables and display the result in same form (id, tel, login, pass, type), cutting off the replays.

PS. I'm new, and join-s for me is not yet entirely clear
April 19th 20 at 12:35
1 answer
April 19th 20 at 12:37
(SELECT ...)
UNION (SELECT ...)
UNION (SELECT ...)
...
While there were a view in which work with the table. It works, but I would like to know maybe there is more elegant solution? - emery.Heller73 commented on April 19th 20 at 12:40
Gracefully - to make one table out of five.

How? To answer this question we need to understand why/why now five tables. - ken.Stanton commented on April 19th 20 at 12:43

Find more questions by tags MySQL