CODEWITHSUNDEEP
sqlbusiness-intelligencebusiness-objectsintersystems-cache
Paul
Paul

Reputation: 69

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).

Upvotes: 0

Views: 277

Answers (1)

DocZerø
DocZerø

Reputation: 8557

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

Reference:

Upvotes: 2

Related Questions