Posted by sweetpotatop on 06/26/07 15:02

Hi,

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

Any advice?

Thanks in advance. Your help would be greatly appreciated.
Wanda

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

[Reply to this message]