General information
Forum:
Microsoft SQL Server
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only