Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql view where tables have same column name combine results

SELECT table1.Column1, table1.Column2
FROM table1

UNION

SELECT table2.Column1, table2.Column2
FROM table2
Comment

PREVIOUS NEXT
Code Example
Sql :: postgresql cast 
Sql :: oracle replace 
Sql :: mysql CAST(amount as float) 
Sql :: mysql set id auto increment 
Sql :: change default schema sql server 
Sql :: sql query duplicate rows 
Sql :: mysql limit rows 
Sql :: laravel get sql query eloquent with parameters 
Sql :: pluck in query builder 
Sql :: mamp mysql path mac 
Sql :: sql count distinct group by 
Sql :: oracle insert or update 
Sql :: When mysql server would not work in xampp 
Sql :: how to drop all tables in postgresql 
Sql :: min salary in sql 
Sql :: declare variables sql 
Sql :: concatenate two strings in sql 
Sql :: create table in sql 
Sql :: Check user permissions on postgres database 
Sql :: install squirrel sql ubuntu 
Sql :: mysql remove html tag 
Sql :: sql pagination offset 
Sql :: create view in sql 
Sql :: update auto increment value in mysql 
Sql :: 1) PostgreSQL DESCRIBE TABLE using psql 
Sql :: remove space in sql server 2012 
Sql :: how to put value in variable mysql 
Sql :: sort by sql 
Sql :: sql date format dd-mm-yyyy 
Sql :: mysql version 
ADD CONTENT
Topic
Content
Source link
Name
6+6 =