/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 vote121 views1 answer
Psql attribute cannot login
SQL
-1 vote151 views1 answer
Mysql faster insert
SQL
1 vote116 views1 answer
Sql pick random row
SQL
0 vote133 views1 answer
Mariadb change column type
SQL
0 vote112 views1 answer
Mysql date minus 1 day
SQL
0 vote121 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote114 views1 answer
Java sql connection
SQL
1 vote130 views1 answer
Drop primary key oracle
SQL
0 vote134 views1 answer
MySQL import data from large CSV file
SQL
1 vote116 views1 answer
Moodle query first user access
SQL

Share