Multiple database joins

[Krish2459_58]

Hi,

I need to write a sql join on multiple databases like below.

Property_Notes:

SQL SELECT 

F_Pm_Property.PMP_SEQ,

F_Notes.Details,

F_Notes.Heading

FROM F_Pm_Property

LEFT OUTER JOIN F_NotesProperty ON F_Pm_Property.PMP_SEQ = F_NotesProperty.PMP_SEQ

LEFT OUTER JOIN F_Notes ON F_NotesProperty.F_Notes_SEQ = F_Notes.F_Notes_SEQ;

Now for  F_Pm_Property the source was changed to  new database "public"."property".

Please help me how to integrate the new database in the above existing above sql join logic.

Thanks..

[MayilVahanan · Accepted solution]

HI

Try to load into 2 set 

Property_Notes:

SQL SELECT Distinct

PMP_SEQ as PMP_SEQ

FROM "public"."property".F_Pm_Property;

ODBC Connectivity;

Left Join(Property_Notes)

SQL SELECT Distinct

F_NotesProperty.PMP_SEQ as PMP_SEQ,

F_Notes.Details,

F_Notes.Heading

FROM F_NotesProperty 

LEFT OUTER JOIN F_Notes ON F_NotesProperty.F_Notes_SEQ = F_Notes.F_Notes_SEQ;

Hope it helps