请教一个挺复杂的MySQL问题。

Question

万分感谢！！！

Answer 1

select t1.date,
       t1.id,
       t3.saleCount,
        (select sum(tb3.saleCount) from table3 tb3 
            where tb3.id in (select t11.id from table1 t11,table2 t22 where 计算经纬度的条件 and t11.dates = t1.dates and t11.pro = t1.pro and t11.city = t1.city and t11.id <> t1.id and t22.id = t11.id))
    from table1 t1,table2 t2,table3 t3
    where  t3.id = t1.id and  t2.id = t1.id

简单的想了一下，先看看把，不一定对