/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 vote246 views1 answer
Postgresql port 5432 not open
SQL
1 vote213 views1 answer
Mysql select month and year
SQL
9 votes208 views2 answers
Default number in sql
SQL
15 votes238 views5 answers
If null mysql
SQL
0 vote215 views1 answer
Opensuse stop MySQL
SQL
0 vote253 views4 answers
Sql rownum
SQL
0 vote228 views1 answer
Oracle temporary table
SQL
-2 votes234 views1 answer
No module named '_sqlite3
SQL
1 vote236 views2 answers
Laravel get sql query eloquent with parameters
SQL
1 vote240 views1 answer
Round function in sql oracle
SQL

Share