/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 vote158 views1 answer
Sql select random procentage from rows
SQL
0 vote154 views1 answer
Oracle enable chain
SQL
0 vote153 views1 answer
Postgresql auto increment not working
SQL
0 vote148 views1 answer
Sql orcale i forgot what my name & password was
SQL
2 votes153 views2 answers
Laravel query builder toSql
SQL
0 vote174 views1 answer
Get total and distict row diff in sql
SQL
2 votes185 views1 answer
Merge two columns in sql oracle
SQL
0 vote152 views1 answer
Mysql root permission denied lost
SQL
0 vote144 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
2 votes168 views1 answer
Coalesce sql
SQL

Share