I need to create an expression called Sales by using the following fields:
Quantity
Price
Discount
I already know i need to take Quantity and multiply it by the price and minus the discount. I can do that manually in expressions but i need to create a set expression and it may not be done by using a variable. Can anyone help me create it in the script or something?
Your "ProductID" field exists in the two tables you are loading, "SalesOrderDetail" and "Product". The error ODBC is throwing and you posted above means that when you do the SQL query, and one fieldname exists in more than one table, you must specify the name of the table from where you want to get that field.
Take into account that the ODBC passes the same statement you have written, so if it has errors, the query won't be executed. I guess that you will get the same error if you perform the same query in your SQL console.
.png "Miguel_Angel_Baeyens"){kind=avatar}
