I would like to create VIEW for DB2400 which has multiple inner join. I've managed to create view with single inner join as follows:
CREATE VIEW MYCOLLECTION/VIEW1 AS SELECT a.ShipVia , b.ShipperID FROM
MYCOLLECTION/Orders A INNER JOIN MYCOLLECTION/Shippers b ON A.ShipVia = B.ShipperID
But with multiple inner join gives SQL0104 syntax error as follows:
Message . . . . : Token was not valid. Valid tokens: ON FULL LEFT CROSS INNER RIGHT USING.
I've tried to create multiple inner join view using iSeries Navigator as well as using 5250 emulator (STRSQL). But it seems that DB2400 doesn't support creating multiple inner join view. Is it true?
If not please let me know how to create so.
Thanks in advance.
CREATE VIEW MYCOLLECTION/VIEW1 AS SELECT a.ShipVia , b.ShipperID FROM
MYCOLLECTION/Orders A INNER JOIN MYCOLLECTION/Shippers b ON A.ShipVia = B.ShipperID
But with multiple inner join gives SQL0104 syntax error as follows:
Message . . . . : Token
I've tried to create multiple inner join view using iSeries Navigator as well as using 5250 emulator (STRSQL). But it seems that DB2400 doesn't support creating multiple inner join view. Is it true?
If not please let me know how to create so.
Thanks in advance.
Comment