多表取不重複值

兩章表...找出範圍內的所有值..並且不重複
● union all 重複
● union 不重複

group by 是決定重不重複的關鍵。

select
        *
from (
        select
                ProductName, Money
        from
                TABLE_A
        where
                Time between '2009-08-04' and '2010-05-07'
                                                                               
        union all
                                                                               
        select
                ProductName, Money
        from
                TABLE_B
        where
                Time between '2009-08-04' and '2010-05-07'
      ) as tmp
group by ProductName, Money

取得SQL 時間區間

取得 30 天內的資料

TO_DAYS(NOW()) - TO_DAYS(A2.ModifyTime) <= 30