>>This is exactly what I gave you in one of my messages as well.
>>
>>
Re: Functions in a select Thread #
1341594 Message #
1341631>
>Almost but not quite. Cetin's works, your doesn't. Note the difference in the last ON clause.
>
>Thanks for your help anyway. I still learned something from the discussion.
Except for a little typo (myAmount used in inner SQL) they are same. I haven't read the whole thread before replying, otherwise would only correct the typo:)
Cetin