/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

0 vote140 views1 answer
Get role postgres
SQL
4 votes132 views1 answer
Datepart postgres
SQL
2 votes155 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote107 views1 answer
Postgresql add leading zeros
SQL
0 vote92 views1 answer
Mysql date + 1 day
SQL
4 votes151 views1 answer
For loop postgresql
SQL
3 votes128 views1 answer
Pl sql check if variable is empty
SQL
2 votes137 views2 answers
Oracle multiple insert
SQL
4 votes155 views2 answers
DB::transaction
SQL
1 vote161 views3 answers
Postgresql crete view
SQL

Share