9 lines
176 B
MySQL
9 lines
176 B
MySQL
|
SELECT *
|
||
|
|
FROM
|
||
|
|
{{ ref('fact_reviews') }} fr
|
||
|
|
LEFT JOIN
|
||
|
|
{{ ref('dim_listings_cleansed') }} dl
|
||
|
|
ON
|
||
|
|
fr.listing_id = dl.listing_id
|
||
|
|
WHERE
|
||
|
|
fr.review_date < dl.created_at
|