/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 vote263 views2 answers
Update all linkedserver tables with openquery on db
SQL
1 vote265 views1 answer
Oracle create program if no exists
SQL
1 vote254 views1 answer
Postgres get timestamp
SQL
1 vote275 views1 answer
Create new table in SQL from old table with data
SQL
0 vote271 views1 answer
Creation d'un trigger sql
SQL
0 vote271 views1 answer
Cast float mysql
SQL
0 vote274 views2 answers
How to tun mysql on ubunto
SQL
0 vote277 views1 answer
Guid string to binary better
SQL
0 vote297 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote282 views1 answer
Oracle dynamic select into
SQL

Share