Access this solution immediately by signing up as a member of FoxproAnswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.
Question
Exist Query
I can grab the orders with the oline='FREGHT' but now I want to get only the ones that have oline='FREIGHT' > 1
* Distinct on ohcust and not exists on item='freight'
Select Distinct ohcust, cmname, ohsta3, olico, oliloc, ohviac, ohvia, cmphon From cCustGroupViaA As cust1 Where Exist (Select ohcust From cCustGroup As cust2 ;
where cust2.ohcust=cust1.ohcust And cust2.olitem='FREIGHT') Into Cursor cOrdersWithoutFreightViaA readwrite
1: 2: 3:
Solution
About this Solution
Sign up Now to View This Solution- Zone
- general
- Tags
- Participating Experts
- 3
- Solution Grade
- A
Posted on 2009-10-21 at 21:05:11ID: 26270593
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.