/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

3 votes269 views2 answers
Oracle drop column
SQL
18 votes213 views6 answers
Mysql create table
SQL
0 vote225 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote221 views1 answer
Sql delete dastabase
SQL
0 vote206 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote265 views1 answer
Sql commands in android
SQL
0 vote233 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote206 views1 answer
Sql pivot without aggregate
SQL
0 vote236 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
1 vote384 views3 answers
Sql subquery
SQL

Share