multiple joins

2 posts / 0 new
Last post
dhuffman63
Offline
Joined: 07/18/2019 - 11:20
multiple joins

Is it possible to create muliple joins across what is 6 different tables like I can do in SQL?  I have 7 Left Outer Joins in an SQL script that I'd like to duplicate withing IDEA.  We are upgraded to version 11.

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi dhuffman63,

IDEA doesn't quite work the same as SQL.  I am not sure what you are trying but did you investigate the Visual Connector in IDEA, it might do what you want.  Here are a couple of videos that will show you how to use Visual Connector.

https://www.youtube.com/watch?v=59hIgDdwVXo&t=633s
https://www.youtube.com/watch?v=r1URy9jiPtI&t=408s