Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 11 Feb 2003 @ 22:31:34 GMT


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


Subj:   Re: I'm stumped...case logic on a left join subquery vs. case logic on a select query
 
From:   McCall, Glenn D

Hi Bruce,

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

Glenn Mc



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023