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
Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.