BizTalk Adapter for HPCC

Build 21.0.7930

JOIN Queries

Inner and outer joins are supported. The query below returns all rows from People and Person that have the same PersonId:

SELECT hpcc::test::person.firstname, hpcc::test::people.personid FROM hpcc::test::person INNER JOIN hpcc::test::people ON hpcc::test::person.personid = hpcc::test::people.personid
Outer joins are also supported. The query below returns all FirstNames from Person and all PersonIds from People when the join condition is met:
SELECT hpcc::test::person.firstname, hpcc::test::people.personid FROM hpcc::test::person OUTER JOIN hpcc::test::people ON hpcc::test::person.personid = hpcc::test::people.personid

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930