Back to list
Views:   0
Replies:  0
Archived
,
Reply 1
Pls. avg A UNION B ?
Active Ice, May 28, 2018
Reply 2
If you are trying to get data from two databases then this best being done with a UNION. A UNION  combines two separate queries into one. 

A little bit more background about the mathematics behind SQL:
You need to see tables and queries as a set of data, with function as UNION and INTERSECT you are able to manipulate those sets.
In example:

A = {1,2,3}
B = {a,b,c}
C = {a,1,5}

D = A UNION B = {1,2,3,a,b,c}
E = A INTERSECT B = {1}

There are more possible operations you can do on entity sets, but I think a UNION is the solution to your problem. 
SELECT column1, column2
FROM table1

UNION

SELECT column1,column2, column3
FROM table2

 
Pippo Foo, Jun 01, 2017
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas