/SQL/How to combine 2 tables in MySQL

How to combine 2 tables in MySQL

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 vote143 views1 answer
SQL authentication error
SQL
0 vote160 views1 answer
Least spark sql
SQL
5 votes140 views5 answers
Sqlite install python
SQL
0 vote142 views1 answer
How to start my sql server on mac
SQL
0 vote142 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote167 views1 answer
Including parameters in OPENQUERY
SQL
0 vote145 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
1 vote148 views1 answer
Mysql size int
SQL
0 vote172 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote150 views1 answer
Postgresql get diff between two dates in Months
SQL

Share