Posted by Ed Murphy on 06/26/07 16:16

sweetpotatop@yahoo.com wrote:

> I got 'Invalid Column Name NewCol1' when I query the following:
>
> Select col1, col2, (some calculation from the fields) as NewCol1,
> (some calculation from the fields) as NewCol2,
> NewCol1 = NewCol2 from
> Table1 inner join Table2 inner join Table3....
> Where
> .....
>
> Basically, I want to find out if NewCol1 = NewCol2 after the
> calculation

You can try this:

select col1, col2, (...) as NewCol1, (...) as NewCol2,
case when NewCol1 = NewCol2 then 'equal' else 'not equal' end

but I don't think that works. This should definitely work:

select col1, col2, (...) as NewCol1, (...) as NewCol2,
case when (...) = (...) then 'equal' else 'not equal' end

• Next in forum: Re: select alias -- invalid column name
• Prev in forum: Re: Database design question - Isolated, unrelated tables
• Thread view: Re: select alias -- invalid column name

[Reply to this message]