/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 votes166 views2 answers
Postgresql remove not null constraint
SQL
2 votes214 views1 answer
Postgresql transaction
SQL
2 votes217 views1 answer
Remove foreign key constraints in postgres
SQL
-1 vote165 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
2 votes211 views1 answer
Oracle current date without time
SQL
0 vote184 views1 answer
Sql delete dastabase
SQL
0 vote214 views3 answers
Sql parenthetical expression examples
SQL
0 vote189 views1 answer
Oracle list datafiles
SQL
0 vote216 views1 answer
Mysql c commands
SQL
0 vote204 views1 answer
How to find symmetric pairs in sql
SQL

Share