高手请进,求翻译一段SQL文
旺仔小牛奶 2015-09-10 09:45:15 小弟最近在搞SQL,但是最近遇到以下形式的命令看不懂,不知道哪位大神可以告诉我什么意思,多谢多谢!
SELECT
basis_date,
Bus_date,
TS,
Kehu_code
FROM TB1
INNER JOIN (select TB21.basic_date,
TB21.Bus_date,
TB21.TS,
TB21.Kehu_code,
TB21.purpose,
(CASE WHEN MAX(TB21.update_date)> MAX(TB21.create_date)
THEN MAX(TB21.update_date)
ELSE MAX(TB21.create_date) end) as MAX_create_date
FROM LCR_IF_BASE as TB21
WHERE TB21.basis_date=v_i_basedate
Group by
TB21.Bus_date,
TB21.TS,
TB21.Kehu_code,
TB21.purpose) as TB2
ON ISNULL(TB1.basis_date,’1900/01/01’) = ISNULL(TB2.basisdate, ’1900/01/01’)
AND ISNULL(TB1.Bus_date,’1900/01/01’) = ISNULL (TB2.Bus_date, ’1900/01/01’)
AND ISNULL(TB1.TS,’ ’)=ISNULL(TB2.TS, ’ ’)
AND ISNULL(TB1.Kehu_code,’’)= ISNULL(TB2.Kehu_code,’’)
AND ISNULL(TB1.create_date, ’1900/01/01’)= ISNULL(TB2. MAX_create_date,’ 1900/01/01’) OR ISNULL(TB1.update_date, ’1900/01/01’)= ISNULL(TB2. MAX_create_date,’ 1900/01/01’))