Sql

create table yourTableName
(
   select *from yourTableName1
)
UNION
(
   select *from yourTableName2
);

SELECT user_id, user_name
FROM users
UNION
SELECT organization_id, organization_name
FROM organizations

PREVIOUS	NEXT

Code Example
Sql :: mysql get last 2 month data
Sql :: enable foreign key checks postgres
Sql :: alter table myisam to innodb
Sql :: mysql compare timestamp in minutes
Sql :: How to drop procedures in mysql ?
Sql :: mysql to uppercase
Sql :: sql server last 2 days
Sql :: division by zero postgres
Sql :: sql number columns
Sql :: mysql count by month
Sql :: sql count total by foreign key
Sql :: sql precent format
Sql :: postgresql import data from csv
Sql :: WHERE not regex in SQL
Sql :: create table with index mysql
Sql :: pagination in sql
Sql :: how to find all children of a record with only parent ID in sql
Sql :: sqlite insert or update
Sql :: pl sql
Sql :: odd record sql query
Sql :: unable to convert mysql date/time value to system.datetime
Sql :: mysql locate
Sql :: postgres default value
Sql :: sql create table with data
Sql :: SQL Subquery and JOIN
Sql :: tablas bootstrap responsive sql server para datos vivos
Sql :: get locked tables sql server
Sql :: sql order by two columns
Sql :: difference between 2 query results sql server
Sql :: sql search all tables for attributes