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