Hi all...

It's been a while since i had to write any SQL stuff and looking at some of my old code has had me scratching my head.
I currently have a Stored Procedure select statement for my website product search facility.

This code uses CONTAINSTABLE on one full-text indexed table.

old code
Code:
SELECT 
ClientProducts.ClientID, 
FT_TBL.ProductID, 
FT_TBL.ManufacturerID, 
FT_TBL.Product, 
FT_TBL.Image2, 
FT_TBL.Price, 
FT_TBL.dateadded, 
KEY_TBL.RANK, 
COUNT(ClientOffers.ProductID) AS QtyOffers
FROM dbo.Products
AS FT_TBL 
INNER JOIN dbo.ClientProducts 
ON FT_TBL.ProductID = ClientProducts.ProductID
LEFT OUTER JOIN 
ClientOffers ON FT_TBL.ProductID = ClientOffers.ProductID 
AND ClientOffers.ClientID = ClientProducts.ClientID 
INNER JOIN CONTAINSTABLE(dbo.Products, *, 
@Parm1, @Parm2) AS KEY_TBL
ON FT_TBL.ProductID = KEY_TBL.[KEY]
WHERE (ClientProducts.ClientID = 100)
GROUP BY dbo.ClientProducts.ClientID, 
ClientOffers.ProductID, 
FT_TBL.ProductID, 
FT_TBL.Product, 
FT_TBL.Image2, 
FT_TBL.Price, 
FT_TBL.dateadded, 
FT_TBL.ManufacturerID, 
KEY_TBL.RANK
ORDER BY KEY_TBL.RANK DESC;
Now i need a similar statement, but using two full-text indexed tables.
The tables are Products and Keywords

new statement
Code:
SELECT
dbo.Products.ProductID, 
dbo.Products.Product, 
dbo.Products.image2, 
dbo.Products.Price, 
dbo.Products.dateadded, 
dbo.Keywords.Keyword
FROM
dbo.Keywords 
INNER JOIN
dbo.ProductKeywords 
ON dbo.Keywords.keywordID = dbo.ProductKeywords.KeywordID 
INNER JOIN
dbo.Products 
ON dbo.ProductKeywords.ProductID = dbo.Products.ProductID
WHERE(dbo.Products.Product = N'REGS20 - FUMAX Smoke Pellets')
OR (dbo.Keywords.Keyword = N'REGS20')
I also need the RANK column for Ordering.

If anyone can help I'd be most grateful.

Thanks in advance
Andy