UNIONALL of two tables with an Alias (Select Statement syntax)

Hi,

I am at beginner level with Birst and it is dificult for me to find in internet a place where I can see help for select statement syntax.

I am trying to append two columns in this UNIONALL table but it says there is an error:

(
SELECT
[o.UWI_BORE],
[o.REGION_DBU]
FROM
[Pozos Oeste] 'o'
WHERE
[o.REGION_DBU] <> 'NO OPERADO'

UNIONALL

SELECT
[s.UWI_BORE],
[s.REGION_DBU]
FROM
[Pozos Sur] 's'
WHERE
[s.REGION_DBU] <> 'NO OPERADO'
) 'p'
LEFT JOIN
SELECT
c.Latitud,
c.Longitud
FROM
Coordenadas 'c'
ON p.NOMBRE_POZO = c.NOMBRE_POZO

Someone can help me to find the error and if it is possible recommend me a place where I can find help for this cases or maybe where I can see examples of different scenarios please,

Thanks

Find more posts tagged with

Comments

Pierre Nolte

Hi!

Alias does not work in the input query.

If you'd add the join in each union script then it should work.

Legacy Contributor

If one (or more) of my UNION select statements require joins or aliases or where clauses anything else other than a pure "SELECT...FROM..." I will usually put them in their own scripts and then UNION from those scripts so that each part is as simple as possible.

Pierre Nolte

Works as well but is adding processing time as you're staging the data.

Maintenance of the script object might as well be another topic to be considered.

Diane McElhiney

Also, consider the best environment for the data consolidation. If these two sources are continually UNION'ed, are extracted from the same source, and don't need to be referenced separately in other Birst scripted sources, then a Query Based Object in Modeler Connect is a better option. The resulting staged data can then be join in a LEFT OUTER JOIN. The overall processing cycle time benefits.

Copyright © 2025 Infor. All rights reserved.