/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 vote156 views1 answer
Postgresql delete limit
SQL
0 vote108 views1 answer
How to fetch highest score in minimum time using mysql
SQL
4 votes157 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote156 views2 answers
How to update the multiple rows in sql
SQL
2 votes144 views2 answers
How to check database username and password in postgresql
SQL
9 votes143 views2 answers
Get first 3 letters in sql
SQL
11 votes329 views4 answers
Round in sql
SQL
1 vote150 views1 answer
Psql filed name alter
SQL
1 vote178 views1 answer
Encrypt password postgresql
SQL
0 vote161 views1 answer
Select distinct after join
SQL

Share