>>select * from view_expandedsmartsafetrans where eventcode = 'DECL' and verifyid = 0 >>>
>select *; > from view_expandedsmartsafetrans VEXP; >LEFT JOIN VER ON VER.verifyid = VEXP.verifyid AND VEXP.transaction < SomeDate >where VEXP.eventcode = 'DECL'; > and VEXP.verifyid = 0 OR VER.verifyid IS NOT NULL >>NOT TESTED!
DECLARE @selectdate DATETIME SELECT @selectdate = '2015-10-31' select * from view_expandedsmartsafetrans where eventcode = 'DECL' and verifyid = 0 OR (verifyid <> 0 AND verifyid IN (SELECT idcol FROM smartsafetrans WHERE eventcode = 'VER' AND postingdate < @selectdate ))This worked.