0

Join in alias table

Hi everyone!

 

I have 3 tabled with join like this: URIM->BTN->AREA

I have created alias table BTN_1 from BTN with same join. And how i can get name filed in AREA table from URIM via BTN_1(maybe it always via BTN) ? such as URIM.BTN_1.AREA.name

 

sorry for my English. thank you !

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • All fields in Incorta are referenced using this notation <schema>.<table>.<field>. Thus, you would reference the field as <schema>.AREA.name. In the insight you're developing, you'd want to ensure you're setting the base table to BTN_1 to get the right join path.

    Like
Like Follow
  • 2 mths agoLast active
  • 1Replies
  • 16Views
  • 2 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!