/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 vote389 views1 answer
Mysql show schema
SQL
0 vote377 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
22 votes297 views4 answers
Mysql date format
SQL
1 vote298 views2 answers
Sql multiline comment
SQL
0 vote313 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote320 views1 answer
Oracle tablespace autoextend
SQL
0 vote307 views1 answer
Firebird where
SQL
2 votes319 views1 answer
Set auto increment from 1
SQL
39 votes360 views5 answers
Sql drop column
SQL
0 vote329 views1 answer
Psql initialization
SQL

Share