Archives of the TeradataForum

Message Posted: Mon, 23 Feb 2004 @ 23:55:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

You're right that it's doing a cross join. But inner joins DO NOT require an ON clause.

sel <whatever>
from tb1,t2;

is just fine.

	<Prev	Next>		<<First	<Prev	Next>	Last>>