compare two columns from two different tables

[rvnth]

Hi there, 

Is there a method to compare two columns (feature_purchased_date and email_sent_date) belonging to different tables? I want to retrieve records where feature_purchased_date from the "feature" table is greater than email_sent_date from the "recipient delivery logs" table.

Thank you in advance

[Heku_ · Accepted solution]

Hello, @rvnth. Do those tables have any field for the reconciliation? If they do, you can query one of the tables, enrich it with the other reconciliating by that field and do a split with the condition feature_purchased_date on or after email_sent_date.

Hope this helps!

Regards.