hi! I need help, please.
I have multiple tables, say 3 tables
table 1 table 2 table3
date from date from date from
date to date to date to
place place place
product product distance
price customer price
price
I want to combine all the data from the 3 tables and get the sum of all the prices with a given condition that the query date should be within the range of date from and to of all tables. Worst scenario, all date from and to are not equal.:banghead:
Hope someone could help me.
I have multiple tables, say 3 tables
table 1 table 2 table3
date from date from date from
date to date to date to
place place place
product product distance
price customer price
price
I want to combine all the data from the 3 tables and get the sum of all the prices with a given condition that the query date should be within the range of date from and to of all tables. Worst scenario, all date from and to are not equal.:banghead:
Hope someone could help me.