Confirm SQL Code for List Manager

Thanh Nguyen $organization over 6 years ago

Hi guys,

We are trying to make a list which shows a list of constituents with at least 1 order in ticket history, and their account creation date is within last 30 days from today.

Could you please confirm if this SQL code is correct?

Select A.customer_no

From T_CUSTOMER A left join T_TICKET_HISTORY B

ON A.customer_no = B.customer_no

Where A.create_dt >= dateadd(DAY,-30,getdate()) and B.order_no is not null and A.inactive = 1

If it is not correct, could you please provide your inputs?

Thank you very much,

Tom Nguyen

Parents

Gawain Lavers $organization over 6 years ago

Technically, doing an inner join on T_TICKET_HISTORY will accomplish the same thing as your LEFT OUTER/NOT NULL, but don't forget to do "SELECT DISTINCT", as you will get multiple rows for each match in T_TICKET_HISTORY, and List Manager won't like that.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Cancel

Reply

Gawain Lavers $organization over 6 years ago

Technically, doing an inner join on T_TICKET_HISTORY will accomplish the same thing as your LEFT OUTER/NOT NULL, but don't forget to do "SELECT DISTINCT", as you will get multiple rows for each match in T_TICKET_HISTORY, and List Manager won't like that.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Cancel

Children

No Data