Archives of the TeradataForum
Message Posted: Wed, 18 Feb 2004 @ 21:14:23 GMT
I think it is doing a CROSS JOIN. INNER JOIN requires the ON clause.
A better way is to say like this:
FROM Table A CROSS JOIN Table B
In that case, you don't need the ON clause and the Statement is more readable.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|