/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

54 votes362 views6 answers
Sql rename column
SQL
0 vote235 views1 answer
C# select Mysql
SQL
0 vote250 views1 answer
Mariadb cast null to 0
SQL
0 vote237 views1 answer
Sql menampilkan data tabel
SQL
0 vote224 views1 answer
Connect postgresql using a connection string
SQL
4 votes230 views1 answer
Oracle table statistics last analyzed
SQL
1 vote227 views1 answer
How to make a select in sql
SQL
0 vote221 views1 answer
Select max salary from each department in sql
SQL
1 vote244 views1 answer
Sql first
SQL
2 votes196 views4 answers
Mysql change database character set to utf8mb4
SQL

Share