/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 vote251 views1 answer
Mysql date without time
SQL
4 votes275 views1 answer
How to check last gather stats on table in oracle
SQL
1 vote218 views2 answers
Mysql trim spaces
SQL
0 vote218 views1 answer
Sql add calculated column
SQL
0 vote215 views1 answer
Cast as decimal postgresql
SQL
0 vote211 views7 answers
10 random questions use python and SQL
SQL
0 vote203 views1 answer
Stuff in sql server
SQL
0 vote190 views1 answer
Duplicate foreign key constraint name
SQL
12 votes227 views2 answers
Update column data type postgres
SQL
1 vote221 views1 answer
Postgresql create table with timestamp
SQL

Share