将他们进行left join连接
时间: 2023-12-02 19:40:12 浏览: 39
将上述引用中的表进行left join连接的SQL语句如下所示:
```
SELECT
a.login_date,
log_cnt,
yd_date,
jk_date,
xd_date,
fk_date
FROM
(SELECT
login_date,
COUNT(DISTINCT customer_id) AS log_cnt
FROM
jfu_dwddwd_user_wk_login_di
WHERE
login_date BETWEEN '20231101' AND '20231110'
AND p_da) a
LEFT JOIN
(SELECT
loan_date,
COUNT(DISTINCT customer_id) AS yd_date
FROM
bd_srcwk_t_order_detail_log
WHERE
loan_date BETWEEN '20231101 000000' AND '20231110 000000'
AND) b ON a.login_date = b.loan_date
LEFT JOIN
(SELECT
login_date,
COUNT(DISTINCT customer_id) AS jk_date
FROM
bd_srcwk_t_distribute_log
WHERE
create_time BETWEEN p_day_id AND y_id
GROUP BY
login_date) c ON a.login_date = c.login_date
LEFT JOIN
(SELECT
loan_date,
COUNT(DISTINCT customer_id) AS xd_date
FROM
bd_srcwk_wk_loan_order
WHERE
loan_date BETWEEN '20231101 000000' AND '20231110 000000'
AND p_day_id = date_sub(getdate(), 1)
GROUP BY
loan_date) d ON a.login_date = d.loan_date
LEFT JOIN
(SELECT
loan_time,
COUNT(DISTINCT customer_id) AS fk_date
FROM
wbdrm_loan_performance
WHERE
loan_time BETWEEN '20231101 000000' AND '20231110 000000'
AND p_day_id = date_sub(getdate(), 1)
GROUP BY
loan_time) e ON a.login_date = e.loan_time;
```