Hi I am stuck in figuring it out how to write the syntax for a select statement which is like the following:
Basically I need to return all the businessunits which are critical but are not available in the history table for a requestid=22 and requeststatus=1.
The TSQL statement look like the following:
select businessunitid from businessunit where businessunitid NOT IN
(select businessunitid from history where requestid=22 and requeststatusid=1) and critical='1'
This is what I was trying to write sysntax for the filter in :
Dim filter As New PredicateExpression
filter.Add(New FieldCompareSetPredicate(DAL.BusinessUnitFieldIndex.BusinessUnitId, Nothing, DAL.HistoryFieldIndex.BusinessUnitId, Nothing, SetOperator.NotEqualAny, Nothing))
any assistance would be most appreciated.
Thanks in adavance
