Posted by billdonovan1947 on 02/01/06 07:37

Hi,

I am getting the following error from the query below against SQL
Server 8.00.2039 (SP4)

Error:
====
Server: Msg 107, Level 16, State 2, Line 1
The column prefix 'd' does not match with a table name or alias name
used in the query.

Select Statement:
=============
select ....
from trades a,
gems_product_groups b,
portfolio_nav_mapping c,
products d,
limit_types e
left outer join gems_prod_trade_mod f on d.product_id =
f.product_ID

I know this was a known bug in MS-SQL7, but I thought it had been fixed
in 2000.

Can anyone help?

Thanks

• Next in forum: Re: Msg 107, Level 16, State 2, Line 1
• Prev in forum: Re: How to find first not null value in column
• Thread view: Msg 107, Level 16, State 2, Line 1

[Reply to this message]