Archives of the TeradataForum
Message Posted: Fri, 13 Sep 2002 @ 17:24:55 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|