/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 vote190 views1 answer
Price-colour
SQL
12 votes228 views6 answers
Change mysql root password
SQL
0 vote172 views1 answer
Month mysql
SQL
1 vote236 views2 answers
Install sql server management studio ubuntu
SQL
0 vote241 views1 answer
Find and replace query in wordpress\
SQL
9 votes199 views1 answer
Mysql check date range
SQL
0 vote217 views1 answer
Delete a temporary table mysql
SQL
0 vote201 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
1 vote197 views1 answer
Drop df constraint sql server
SQL
0 vote213 views1 answer
Trigger vérifier stock
SQL

Share