adapter,v2.6,vs2010
I have statement below but want to use SetOperator.In how do i do SetOperator.NotIn
bucket.PredicateExpression.Add(New FieldCompareSetPredicate(VwCustomerFields.CustomerId, Nothing, VwResellerCustomerFields.CustomerId, Nothing, SetOperator.NotEqual, (VwResellerCustomerFields.ResellerId = ResellerID)))
This is what i want to do....
Select * from customers where Cstomerid not in
(select custmerid from customers where type=9)