I have 2 tables;
Table1: CALCULATIONS containing fields [Date], [time], Final_Destination, pstn
Table2: s_TrackRealCDR containing fields DateID, SDate, EDate, Commission
I want to make a VIEW where I want CACULATIONS table to display together with Commission column from s_TrackRealCDR table where Date is between EDate (start date) and EDate (end date).
I hope I am able to explain what I need. Nevertheless I am available to give some examples.