Hello smart people!
Our Tessitura guru moved on to other SQL pastures, and I need to make an edit to a SQL statement but don't know how.
So, I have this snippet of info:
(SELECT a1.customer_no
FROM vs_package_history AS a1 WITH (NOLOCK)
WHERE a1.pkg_amt >= 400
I *think* need to change the pkg_amt to order amount, but don't know how to say that. Can you help??
Thanks in advance!
Lesley, what are you trying to accomplish with this bit of SQL?vs_package_history typically doesn't have an order amount in it, so you might need to look at a different view or table to get the information you're after.
You can join on order no on t_order. Example below.
select distinct a.customer_no from vs_package_history a join t_order b on a.order_no = b.order_no where b.tot_paid_amt >= 400
Travis