I tried to join multi-tables in one statement like below:
select a, b, c
join table 2
join table 3
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?
"[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"
You need to consult the documentation/community for the database you are using as this is not related to DbVisualizer.