/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

2 votes214 views1 answer
Power query concatenate
SQL
0 vote200 views2 answers
Zsh: command not found: mysq
SQL
1 vote226 views4 answers
Aggregate function in sql
SQL
1 vote204 views1 answer
Postgresql escape single quote
SQL
0 vote188 views1 answer
Cast for print sql
SQL
0 vote256 views1 answer
Postgres row expiration
SQL
3 votes195 views2 answers
Brew start mysql
SQL
1 vote205 views2 answers
Oracle create synonym
SQL
22 votes204 views6 answers
Create sql table
SQL
0 vote188 views2 answers
Functions with parameters SQL
SQL

Share