/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 vote150 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote127 views1 answer
Mysql select where field like in list
SQL
0 vote150 views1 answer
Sql last time database was accessed
SQL
5 votes138 views4 answers
SQL Order of execution
SQL
0 vote131 views1 answer
Mysql count number of occurrences in a column
SQL
7 votes127 views2 answers
What is sql clause
SQL
13 votes171 views6 answers
Mysql remove duplicates
SQL
0 vote120 views2 answers
How to get json data mysql
SQL
0 vote126 views1 answer
Vowels in sql
SQL
0 vote140 views1 answer
Add two days to current date in sql when creating tables
SQL

Share