Let us use the example provided by quantrix :
http://www.quantrix.com/help_resources/ … ources.htm
The link about example is about
1) joining 2 tables ( tbl orders and tbl customers )
2) modifying sql with table (tbl orders extended).
Column in table tbl orders :
Column in table tbl customers:
>Cust Types id
Column in table tbl orders extended:
>orders extended id
>Customers id (let’s consider customers id also exist in this table)
3 of the tables above have the column ‘Customers id’ so they could able to join together.
The example trying to add custom column in table tbl orders extended ‘ adjusted sales price = sale price*1.05’
However, in my case I would like :
sale price * Country id (in table tbl customers) * Date (in table tbl orders)
Any suggestion for the problem above ?