/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 vote196 views1 answer
Order by in codeigniter query builder
SQL
1 vote200 views1 answer
Oracle enable job
SQL
1 vote193 views1 answer
Oracle avg
SQL
0 vote204 views1 answer
Sql #region
SQL
2 votes173 views2 answers
Get all columns from table sql
SQL
0 vote175 views2 answers
How to start postgresql laravel
SQL
0 vote196 views1 answer
Sql datediff month
SQL
0 vote229 views1 answer
Arithmetic expression in sql
SQL
2 votes173 views2 answers
How to create an empty table from an existing table
SQL
1 vote325 views1 answer
Sql injection
SQL

Share