I'm joining a subquery to outer query and need to see the results of everything, even ones that the joining is not matching.
I tried to create a Temp table for the outer query and a temp table for one of the inner query then tried to join on that. I tried to do an insert to outer query, but it gave me a ton of rows. I'm thinking of a Merging statement with a target table with matching and nonmatching.
Select col a --- Can have Nulls or blanks in Table A col b col c col d col e from table a left join ( select col a This will never have blanks or nulls col b col c col d col e from table)b on a.cola = b.cola -- even though there might be nulls in table A show them. so A.ColA <> B.ColA and carry them to the next subquery and a.colb = b.colb and a.colc = b.colc Left join Whatever is NUll for ColA will go to the next subquery (select col a col b col c col d col e from table)C on a.colb = b.colb and a.colc = b.colc
When there is a match it will show up, but I need to see the ones that have no match so I can have it go to the next subquery to see if there's a match.