Re: SQL Create table with a UNION query returns error

[Dan <dan27649@xxxxxxxxx>]

Excellent catch, Mike!  The CA* name was the original attempt, and from
where the error message was copied/pasted.  The AR* name is the one I
settled on, but it still gave the same error.

So, while Rob's suggestion resolved the issue for me, the problem with the
error associated with the UNION clause appears to be a defect.

Thanks,
- Dan

On Thu, Feb 8, 2018 at 12:45 PM, Mike Jones <mike.jones.sysdev@xxxxxxxxx>
wrote:

> Hi Dan,
>
> I notice that in the error message, it states table name "CA0119W".
>
> In your SQL, it builds table name "AR0119W", a different name.
<snip>