Archives of the TeradataForum
Message Posted: Tue, 11 Jul 2006 @ 12:29:07 GMT
| Subj: | | Re: Join Index error |
| |
| From: | | Victor Sokovin |
David, any joy with the JI?
What I have noticed (I did try a few cases in the meantime) is that the parser seems to become more flexible if instead of "LEFT JOIN" I just
specify "JOIN". I don't think this will make any difference in your case; you would still get the same JI. Try your original definition with only
this modification. I wonder if it works for you like it seems to be working for me.
My first suggestion should probably also do the job but it is such an overkill to have duplicate columns just because of the parser. I thought
I should mention this lighter solution.
Regards,
Victor
| 
