RE: SQL Create table with a UNION query returns error

[Roger Harman <roger.harman@xxxxxxxxxxx>]

Some tips on formatting...  

There are plenty of SQL "prettifier" sites that you can use to format easily readable SQL
-or-
Use SQL Workbench/J or SQuirreL to do it
-or-
I think RDi has a formatting option for embedded
-or-
I recall hearing that ACS has a reformatter but I have never gone looking for it.



-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan
Sent: Thursday, February 08, 2018 8:44 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL Create table with a UNION query returns error

Rob, thank you for your reply.  That did the trick.  I had a feeling that
the left outer join was what I needed, but I wasn't thinking clearly last
night to connect with the CASE clauses and checking for null.  I had a
vague thought to use COALESCE, but it wasn't clicking when I tried to flesh
it out.

Yes, I need to force myself to use explicit JOIN clauses. Old habits plus
the vast majority of the joins we use are inner joins, hence the "lazy"
style.

Thanks again,
- Dan

On Thu, Feb 8, 2018 at 7:50 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

> Several things wrong with this statement.
<snip>