/SQL/How to combine 2 tables in MySQL

How to combine 2 tables in MySQL

Mysql join two tables

SELECT user_id, user_name
FROM users
UNION
SELECT organization_id, organization_name
FROM organizations

1

How to combine 2 tables in MySQL

create table yourTableName
(
   select *from yourTableName1
)
UNION
(
   select *from yourTableName2
);

0

Source: tutorialspoint.com

Similar codes

0 vote238 views2 answers
Sql server Insert Into table
SQL
0 vote226 views1 answer
Power query case when
SQL
0 vote236 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote234 views1 answer
Sql DATE = GETDATE()
SQL
0 vote223 views1 answer
Oracle step procedure
SQL
1 vote222 views1 answer
Median mysql
SQL
22 votes220 views3 answers
Join three tables sql
SQL
0 vote238 views1 answer
Str_to_date sql server
SQL
2 votes218 views2 answers
Install sqlalchemy
SQL
9 votes239 views2 answers
Nosql databases
SQL

Share