Ambiguous Column Name Problem

I have a table which needs to have a column called rank. When I run the
following query I get an error about the table names being ambiguous. Is
there a way round this. Regards, Chris.
SELECT [Key], productdescriptionid, productdesc_name FROM FREETEXTTABLE
(tblProductDescriptions, *,'biopsy') F JOIN tblProductDescriptions P ON
P.productdescriptionid = F.[KEY]ORDER BY RANK DESC
Sorry I really wasn't thinking. just put F.RANK !!!!!
SELECT [Key], productdescriptionid, productdesc_name FROM FREETEXTTABLE
(tblProductDescriptions, *,'biopsy') F JOIN tblProductDescriptions P ON
P.productdescriptionid = F.[KEY]ORDER BY RANK DESC
"Chris Kennedy" <chrisknospam@.cybase.co.uk> wrote in message
news:OnxD4UKeEHA.3132@.TK2MSFTNGP11.phx.gbl...
> I have a table which needs to have a column called rank. When I run the
> following query I get an error about the table names being ambiguous. Is
> there a way round this. Regards, Chris.
> SELECT [Key], productdescriptionid, productdesc_name FROM FREETEXTTABLE
> (tblProductDescriptions, *,'biopsy') F JOIN tblProductDescriptions P ON
> P.productdescriptionid = F.[KEY]ORDER BY RANK DESC
>
|||does this work?
SELECT [Key], productdescriptionid, productdesc_name FROM FREETEXTTABLE
(tblProductDescriptions, *,'biopsy') F JOIN tblProductDescriptions P ON
P.productdescriptionid = F.[KEY] ORDER BY F.[RANK] DESC
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Chris Kennedy" <chrisknospam@.cybase.co.uk> wrote in message
news:OnxD4UKeEHA.3132@.TK2MSFTNGP11.phx.gbl...
> I have a table which needs to have a column called rank. When I run the
> following query I get an error about the table names being ambiguous. Is
> there a way round this. Regards, Chris.
> SELECT [Key], productdescriptionid, productdesc_name FROM FREETEXTTABLE
> (tblProductDescriptions, *,'biopsy') F JOIN tblProductDescriptions P ON
> P.productdescriptionid = F.[KEY]ORDER BY RANK DESC
>