How would i write something like:

select * from orders as orders1 where orderType = "type1" and orderId not in (select orders2.orderId from orders as orders2 where orders2.orderType = "type2")

Thanks, Matt

You should use **FieldCompareSetPredicate **object to create your NOT IN predicate Use the overload that receives a bool negate parameter and set it to false. This will result in a NOT IN cluase: http://llblgen.com/TinyForum/Messages.aspx?ThreadID=8819&StartAtMessage=0&#48750

Please let us know if you need further help on this.

Sorry, i forgot about the key part:

select * from orders as orders1 where orderType = "type1" and orderId not in (select orders2.orderId from orders as orders2 where orders2.orderType = "type2" AND orders1.date <> orders2.date)

Is there some way to alias the tables in the FieldCompareSetPredicate?

Thanks, Matt

Use an SetObjectAlias method property to set the alias to on the fields you're using to build your FieldCompareSetPredicate. Some examples:

http://llblgen.com/TinyForum/Messages.aspx?ThreadID=9690&StartAtMessage=0&#53850 http://llblgen.com/TinyForum/Messages.aspx?ThreadID=10208&StartAtMessage=0&#56825