sql - SQL - 两列中的日期相等

Question

我有这个查询，并希望仅查看一个表中的有效日期 = 另一表中的更新日期的日期。

SELECT 
    facets_re_group.prospect_nbr, rmr_run_status, insert_date, renewal_date,  
    package_item_cd, quote_type, effective_date, quote_expiration_ind,   
    mhs_lob_code
FROM 
    facets_re_group
INNER JOIN 
    facets_re_cur_package ON facets_re_cur_package.prospect_nbr = facets_re_group.prospect_nbr 
JOIN 
    qo_quote ON qo_quote.prospect_nbr = facets_re_group.prospect_nbr
WHERE 
    insert_date >= to_date('01/01/2020','mm/dd/yyyy') 
    AND package_item_cd = 'HRA' 
    AND quote_expiration_ind IS NULL 
    AND mhs_lob_code NOT IN 'DTL1' 
    AND mhs_lob_code NOT IN 'DTL2' 
    AND mhs_lob_code NOT IN 'VIS1'

标签： sql