Derived table bug - Query Analyzer

Start with a derived table based query like this (tables should exist and connection is on the database):

Select
From (Select Column1
From Table1
Group By Column1
Having Count(*) > 1) dup

After the "dup", type INNER JOIN<space>

Query analyzer closes.

Hi,

Thanks for the bug report. I can reproduce this issue on my system. I will send it to developers for further investigation.
For now, please you use "AS alias" syntax like "SELECT FROM (subquery) AS alias INNER JOIN ..."

	Quote:
	Select From (Select Column1 From Table1 Group By Column1 Having Count(*) > 1) AS dup