/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 vote94 views1 answer
Sql remove non numeric characters
SQL
0 vote46 views1 answer
Sql server is not
SQL
6 votes91 views4 answers
Eloquent to sql with bindings
SQL
0 vote79 views1 answer
Drop all tables in azure sql database
SQL
0 vote96 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote91 views1 answer
Oracle current session details
SQL
0 vote107 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
1 vote85 views1 answer
Sql Split string function
SQL
4 votes85 views2 answers
Mysql how to change default charset
SQL
0 vote87 views1 answer
Plsql check for string in numeric
SQL

Share