/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

1 vote103 views3 answers
What is union in sql
SQL
36 votes94 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote102 views1 answer
Get null value in sql
SQL
0 vote124 views1 answer
Mssql find deadlocks
SQL
0 vote113 views1 answer
SQL: calculate hours from two dates
SQL
6 votes100 views2 answers
Mysql get yesterday
SQL
0 vote90 views1 answer
Export partttion and import in oracle
SQL
4 votes105 views1 answer
Postgres delete last row
SQL
0 vote60 views1 answer
Mysql insert with foreign key
SQL
0 vote98 views1 answer
Mysql database hyphen
SQL

Share