Join (Superseded) Node Full out join
Is it possible to join two nodes with the join (superseded) node? I understand how to write SQL coding, but I am not sure how to write the code for the nodes I am trying to join. For example,
- SELECT C.FirstName, C.LastName, C.Country AS CustomerCountry,
- S.Country AS SupplierCountry, S.CompanyName
- FROM Customer C FULL JOIN Supplier S
- ON C.Country = S.Country
- ORDER BY C.Country, S.Country
How do you replace the "Customer C" and "Supplier S" with Data3sixty coding? I understand that you pull in the columns through the input fields, but I'm not sure about the actual node itself.
Please sign in to leave a comment.
Comments
3 comments