D
D
David2020-04-17 21:21:11
MySQL
David, 2020-04-17 21:21:11

How to make a selection from 5 tables with the same fields by condition in MySql?

There is a base with 5 tables and single fields.
id, tel, login, pass, type
It is necessary to find the value of the field (tel) by searching in all tables and display the result in the same form (id, tel, login, pass, type), cutting off repetitions.

Ps. I'm a beginner and joins are not quite clear to me yet.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Rsa97, 2020-04-17
@Rsa97

(SELECT ...)
UNION (SELECT ...)
UNION (SELECT ...)
...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question