Start a new topic

left join multi tables in one statement

I tried to join multi-tables in one statement like below:


select a, b, c

from table1

join table 2

join table 3

on table1.aa=table2.bb

on table2.bb=table3.cc


It works without issue. But if I change 'join' to 'left join', it doesn't work, and showing below error. Is there anything wrong with my codes, or it simply does not support multi left joins in one statement?


Thank you!


"[Code: -338, SQL State: 42972]  DB2 SQL Error: SQLCODE=-338, SQLSTATE=42972, SQLERRMC=null, DRIVER=4.19.49. 2) [Code: -514, SQL State: 26501]  DB2 SQL Error: SQLCODE=-514, SQLSTATE=26501, SQLERRMC=SQL_CURLH200C1, DRIVER=4.19.49" 

1 Comment

Vincent,


You need to consult the documentation/community for the database you are using as this is not related to DbVisualizer.


Regards


Roger

Login or Signup to post a comment