Archives of the TeradataForum

Message Posted: Fri, 13 Sep 2002 @ 17:24:55 GMT

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

Bruce,

What are SBSCR_SETUP_DEALR_CD and SBSCR_MRKT_CD? Are these columns in a table? If so what table? I think this needs to be clarified. Can you provide more SQL? OR let me know and I can email you a working SQL left outer join statement.

All the database platforms we work with are somewhat finicky when it comes to referencing columns and use of aliases in sql statements that use the outer join syntax, so you need to be very careful.

Column datatype would not produce this error, but it may impact query performance. Check the explain, I am not sure if an explicate conversion is required.

John Grace
Geppetto's Workshop

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