×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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>
midrange.com
