How can we help you today?
left join multi tables in one statement
1 Comment
Roger Bjärevall
said
over 7 years ago
Vincent,
You need to consult the documentation/community for the database you are using as this is not related to DbVisualizer.
Regards
Roger
Vincent Wang
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"