/SQL/Mysql join two tables

Mysql join two tables

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

22 votes272 views3 answers
SQL CHEATSHEET
SQL
0 vote264 views1 answer
Mysql count grouped rows
SQL
2 votes275 views1 answer
Power query concatenate
SQL
0 vote287 views1 answer
Update sql sintax
SQL
0 vote263 views1 answer
On sql table data exists
SQL
1 vote261 views2 answers
Mysql select tables with name like
SQL
0 vote259 views1 answer
Alter table name including schema
SQL
2 votes285 views1 answer
Sqlplus clear screen
SQL
12 votes258 views1 answer
Docker mysql random root password
SQL
0 vote305 views1 answer
Dual in db2
SQL

Share