Hi!

I am not sure what was the error message you were referring to but the first change you need is to rename the 'Group' column, which is a SQL key word.

I changed the query as follows and it seems to be working fine this way:

Select * ,
(Select BasePrice * GroupFactor
FROM TableA a2 INNER JOIN TableC c ON a2.[Group] = c.[Group])
from TableA a
INNER JOIN TableB b ON a.OrderedItem=b.OrderItem

Hope this helps.
Ramona