It’s hard to spot errors when your SQL is one long string of text.
The problem is the brackets:
([open_ord_qty] + [shipped_qty] * [net_price]) AS BKPAMT
I just pasted it in the editor and formatted it. then it was a lot easier to spot.
It’s hard to spot errors when your SQL is one long string of text.
The problem is the brackets:
([open_ord_qty] + [shipped_qty] * [net_price]) AS BKPAMT
I just pasted it in the editor and formatted it. then it was a lot easier to spot.