To write SQL join between two tables you need to select tables that you want to join. Access to left and right tables is provided through variables $table1 и $table2 ...
left join view_servicelistenerport_v2 lp on si.serviceinstance_pk = lp.discovered_serviceinstance_fk join view_servicecommunication_v2 sc on sc.servicelistenerport_fk ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback