How to combine 3 different columns in 1 mysql table?

There are three different tables. I do something like smart search, which offers options. For example writing in the search box “shop” , system there's gonna to offer me the results that I had in mind: email usershop@gmail.com the shop24 store name or a product name little shop. All data is stored in different tables. I want the query to 1 table consisting of 3 columns : EMAIL( shop@gmail.com,1st.shop@mail.ru), SHOP(shop24, null), NAME(null is null(no matching name)). It is clear that every column will selected through LIKE. But how it to thrust in table 1 below in the columns was only unique values without repetitions? Left join requires the attribute on, and I have to add 3 columns to the table and empty space to fill in the null. Give an example or a ready-made request please. Can be in the form of procedure
March 19th 20 at 08:22
2 answers
March 19th 20 at 08:24
union
Union outputs all in 1 column, and I need 3 columns - tracy.Stehr62 commented on March 19th 20 at 08:27
You can give as many columns
SELECT 1, null, null
UNION
SELECT null, 2, null
UNION
SELECT null, null, 3
- margret44 commented on March 19th 20 at 08:30
March 19th 20 at 08:26
SELECT col1, col2, col3 
FROM table1, table2, table3

Find more questions by tags MySQL