/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 vote129 views1 answer
Monthly Birthday SQL Query
SQL
0 vote129 views1 answer
Print orcale
SQL
1 vote148 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote142 views1 answer
Tinydb add table
SQL
0 vote137 views1 answer
Guid string to binary better
SQL
16 votes137 views2 answers
Add column if not exists mysql
SQL
5 votes130 views4 answers
Select random rows sql
SQL
1 vote175 views1 answer
Show databases mysql docker
SQL
0 vote141 views1 answer
Sql remove first character from string
SQL
0 vote133 views1 answer
Oracle sql copy table without data
SQL

Share