How to only import data where the date is less than that in another table?

Ask a Question

I have a question.

I have one table called SurveyData that has columns:

Customer ID, Survey Response, Survey Date

another table called Complaints

Customer ID, Complaint Detail, Complaint Date

I only want to load complaint data for each Customer ID where the Complaint Date is less than or equal to the Survey date for each customer.

i.e i do not care about complaints that happen after the survey date

i tried after the

FROM [.....]

Where [Complaint Date] <= [Survey Date]

but errored.

any ideas?

thanks in advance!

0 Replies