I have the below query which is working fine but its a situation to store the values in a variable and then use in the script but I can not get the actual values because of Customer_Location.
Note * The Customer_No, Customer_Sub has a unique values but the Customer_Location has duplicate values,
Working Code
Select Customer_No,
Customer_Sub,
Customer_Location,
Customer_Name,
Product_Code,
Product_Name,
Qty,
Amount
from table name
Where Customer_No = 500 and Customer_Sub IN(20100,20101) and Customer_Location In(1,3,8,10,15,19,20) or
Customer_No = 600 and Customer_Sub IN(30001,30002) and Customer_Location IN(1,2,4,6,8,11,23,25,27)
Using the Variable
Let vCustomer_No = Pick(Num('500,600'))
Let vCustomer_Sub = Pick(Num('300001,30002'))
Let vCustomer_Loc = Pick(Num('1,3,8,10,15,19,20 ,1,2,4,6,8,11,23,25,27'))
the result data is like this, how to separate the Customer_Loc for the particular Customer_No and Customer_Sub ???
Are you saying you have two data sets. The first contains all your data and the second contains the values you want to filter the first set of data by?
If so can you provide both sets of data and and third table to show the results you are expecting.
