Re: Cool but ugly SQL

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-