I'm trying to join two table ..
i'm trying a left join but its not giving the result i'm expected.....
date(num(round(Date-1))) as MaxDate,
date(num(Date)-8) as StartDate
for table main it has only unique kweekKey but in test1. table it has mutlple kweeekKey ...i want just sumgallon value unique to start date and enddate in main table.......
how do i do this ??
any suggestion plz