Re: Cool but ugly SQL

[vhamberg@xxxxxxxxxxx]

Cool - Birgitta's post was important. I've a question, though. You say you did 
not want Tempfile to be the source of the data. Can you say more - I mean, as 
far as I know, it is irrelevant - TempFile is just a name for the result of the 
common table expression defined by the "with" - the data ultimately comes from 
the original file, too. Anyway, I am just curious about that statement.

BTW, that select statement for the max values could probably also have been 
written in place in the join, as what is called a nested table expression. Not 
always, but usually - YMMV.

Thanks
Vern

-------------- Original message -------------- 
From: Dan <dan27649@xxxxxxxxx> 

> On 6/16/06, Hauser, Birgitta wrote: 
> > This will not work... 
-snip-

> O.k. I think I finally got it. Here's what worked for me: 

-snip-
 
> I didn't want to use TempFile as the source of the data being inserted. 

-snip-