manoel_sa wrote: > There seems to be a problem in 7.4 regarding inner joins: > > ... FROM a INNER JOIN b INNER JOIN c WHERE ... > > does not work (its ok in 7.3).
With 7.4 and 7.3.0.29 we straighten the join syntax a little bit. So the joined table expression have to look like <joined_table> ::= <from_table_spec> CROSS JOIN <from_table_spec> | <from_table_spec> [INNER] JOIN <from_table_spec> <join_spec> | <from_table_spec> [<LEFT|RIGHT|FULL> [OUTER]] JOIN <from_table_spec> <join_spec> In your example the join spec is missing. You have to change your command in one of these ... FROM a CROSS JOIN b CROSS JOIN c WHERE .... or ... FROM a, c WHERE .... For more information have a look at http://www.sapdb.org/7.4/htmhelp/ea/eba4f43e9211d3a98200a0c9449261/frameset.htm Sorry for any inconvenience. Kind regards, Holger _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
