Search code examples
sqlbusiness-intelligencebusiness-objectsintersystems-cache

SELECT Schema.Table.Column -> Column from another table WHERE

Business Objects is generating the following SQL for my query

SELECT Schema.Table.Column->"Column from another table"
FROM Table1, Table2
WHERE  ...

The "Column" in Schema.Table.Column contains the code "A1234", but because of the "->" it's actually looking up the description against another table.

Because "-" and ">" are frequently used in the documentation, I cannot search to find out what the -> does. I am assuming it's something to do with aliasing, but I cannot find reference to -> anywhere. Can someone please at least tell me what I should search to find understanding for ->?

BO version is 6.1b, data source CACHE (don't know the version), UNV was created by a company years ago that are no longer involved, seeing this in Thick Client (which later became known as DESKI).

Solution

  • This seems to be an SQL operator that's defined in Caché SQL and is used as an implicit join.

    Reference: