Skip to content
Advertisement

Using Join and Union to combine results from 2 tables [closed]

I already have a result set using join from multiple master tables with TABLE A as the primary table. Now I’m trying to perform union on table B with joins from masters retained.

This is the query I tried:

This didn’t work

Advertisement

Answer

At first look your have several error

some column name ci.status, ab.descin wrong place,

two from clase

a reference at table a that should be (probably) a reference to t1

a possible valid query could be

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement