/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 vote176 views1 answer
Mysql case when null
SQL
0 vote179 views1 answer
Sql gap missing values
SQL
3 votes211 views1 answer
Oracle user quota on tablespace
SQL
0 vote182 views1 answer
Get all employee of salary if more than in sql
SQL
2 votes220 views1 answer
Oracle kill session by sql_id
SQL
1 vote179 views1 answer
Restart identity postgresql
SQL
1 vote191 views1 answer
Operator does not exist: integer = text
SQL
6 votes182 views1 answer
Oracle list primary key
SQL
13 votes194 views5 answers
Sql default
SQL
1 vote193 views2 answers
Oracle list partitioned tables
SQL

Share