Thanks Everyone,

I used John's suggestion and everything is great.

Regards
Doug Johnston



>>Hi Naomi,
>>
>>Thanks for your reply.
>>
>>I noticed you have 2 selects after the INNER JOIN, so I removed 1 and get a T1 Alias not found error.
>>
>>Maybe the inner join not quite right.
>>
>>Regards
>>Doug Johnston
>>
>>
>I guess it would not work this way. Sorry.