Archives of the TeradataForum
Message Posted: Wed, 11 Feb 2003 @ 22:31:34 GMT
Seems you have a doozy.
I couldn't see the problem relating to the) however, here are some things I noticed and an idea you could try.
1. tieing together a couple of threads, I have queries running on V2R4.1.3 that have aliases on more than 2 tables, so I suspect that Ken was misinformed.
2. The column loc_addr_postl_cd does not include the alias. There is a risk that you might get a product join going on here. Generally a query of the form "select c1, x1.c1 from x x1" is not a good thing to do. I am sure that in earlier versions this would result in a product join between x and x1 - however V2R4.0.3 doesn't seem to do it.
3. Have you run the query in bteq. Often when I get a missing (or missing) message I run the query in bteq and more often than not it will display the actual line that is in error. Sometimes it is not the one that you think it is.
4. If you use an inner join between micro and acct do you still have the problem? What about if you don't bother with the join at all and simply return all the rows from query 1 as a derived table? i.e.
Sel * From ( query 1 ) micro
Hope this might be of some help
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|