/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

10 votes263 views1 answer
How to import database in mysql by cmd
SQL
0 vote293 views2 answers
Sql last updated
SQL
4 votes312 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote299 views1 answer
How to insert multiple values in a single column in sql
SQL
1 vote270 views1 answer
How to drop function in sql
SQL
7 votes284 views2 answers
Mysql default value
SQL
0 vote282 views1 answer
Systems sql
SQL
26 votes283 views2 answers
Mysql workbench download
SQL
0 vote285 views1 answer
Sqlalchemy get schema from database
SQL
1 vote278 views1 answer
Sql eliminare un record
SQL

Share