topic Re: Incorta joins other than the inner joins (=) in Data & Schema Discussions

Incorta joins other than the inner joins (=)

Ruchita — Thu, 09 Mar 2023 06:00:23 GMT

Hi everyone !

A quick question, how can two tables be joined as a union using the Joins section in Schemas ?

If there's another alternative to union two tables, without using Materialized views, i'd be happy to hear about it too.

Thank you !

Re: Incorta joins other than the inner joins (=)

Tristan — Fri, 10 Mar 2023 16:48:10 GMT

Hi Ruchita,

If the tables have the same columns, then you can set up a multi-source table in the physical schema and let Incorta do the union for you. See the documentation for multi-source tables here. That is probably the best way to do it because it allows you to join data from disparate data sources but if the tables are from the same source, you can also just write the union SQL yourself when defining the table.

Hope this helps.

Tristan

Re: Incorta joins other than the inner joins (=)

amit_kothari — Sat, 11 Mar 2023 02:36:03 GMT

One more option is our runtime sql view , it is still a lab feature and we can write a Union sql in that , pls check https://docs.incorta.com/5.2/concepts-incorta-sql-view