Try
Select * from TableA a, b.BasePrice * c.GroupFactor AS Amount
JOIN TableB b ON a.OrderedItem=b.OrderedItem
JOIN TableC c ON c.GroupID = a.Group
>Hi this is what I would like to accomplish.
>
>TableA
>-------
>OrderedItemID
>OrderedItem
>Group
>
>TableB
>--------
>OrderItemID
>OrderItem
>Baseprice
>
>TableC
>--------
>GroupID
>Group
>GroupFactor
>
>
>Select * from TableA a ,
>(Select BasePrice * GroupFactor
>FROM TableA a2
>INNER JOIN TableC c
>ON a2.Group = c.Group)
>INNER JOIN TableB b ON a.OrderedItem=b.OrderedItem
>
>I receive an error when I try this statement.
>
>Thanks for the help,
>
>Alvin
--sb--