/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 vote232 views1 answer
Get only first row mysql
SQL
0 vote248 views1 answer
Bash block size ls /var/lib/mysql
SQL
-1 vote268 views2 answers
Postgresql get last 10 records
SQL
21 votes276 views6 answers
Change column in mysql
SQL
1 vote278 views3 answers
Get all tables postgres
SQL
31 votes254 views3 answers
Sql count(*)
SQL
0 vote261 views1 answer
Sql select by content lenght
SQL
0 vote248 views1 answer
MySQL error code 2068
SQL
3 votes261 views1 answer
Force using index oracle
SQL
0 vote272 views1 answer
Mysql DDL
SQL

Share