Syntax check underlines valid columnname

Hi,
I noticed the following. In the code below, the pr2.posnr does not exist, but the syntax check underlines orr.posnr as the error, and orr.posnr does exist.

SELECT distinct orr.z_lf
, orr.orderid
, orr.posnr
, orr.antal_forp
, pr2.posnr
, pr2.*
FROM orr
LEFT JOIN pr ON
orr.orderid = pr.orderid
AND orr.posnr = pr.orderposnr
INNER JOIN #tmp_order o ON
orr.orderid = o.orderid
INNER JOIN pr pr2 ON
o.orderid = pr2.orderid

I'm using SQL Assistant version 5.0.97, and I run
SQL Query Analyser version 8.00.2039 on my local PC with XP, connecting to a SQL2000 database on a database server in our network.

Hi,

Your database server "tells" SQL Assistant that column "posnr" doesn't exist, but it doesn't say in which specific line the non-existent column is found. Because the exact location is unknown, SQL Assistant finds and highlights the first reference to the column. This is best it can do.