>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.
If it's not broken, fix it until it is.
My Blog