darn comma! ;-)
>>
>>Now I am curious why Sergey's response won't work (aside from the incorrect syntax ;-) )
>>
>>Select a.*, b.BasePrice * c.GroupFactor AS Amount
>>from TableA a,
>>JOIN TableB b ON a.OrderedItem=b.OrderedItem
>>JOIN TableC c ON c.GroupID = a.Group
>>
>
>O well, yours still has syntax error too. :)