Create table rt_apptype_ex
(
	apptype varchar(6) primary key clustered
)

Insert rt_apptype_ex (apptype)
Values ('ppnew'), ('pprev')


Create table rt_appstatus_in
(
	appstatus varchar(4) primary key clustered
)

Insert rt_appstatus_in (appstatus)
Values ('A'),('B'),('DIS'),('DI'),('EXT'),('H'),('L'),('S')

Select ps.*
From 
	PS_TestForOnline ps
		--Excluded: Left outer join with corresponding 'is null' in Where clause
		Left outer join
			rt_apptype_ex rae
			On
				ps.apptype = rae.apptype
		--Included: Inner join
		Inner join
			rt_appstatus_in rai
			On
				ps.appstatus = rai.appstatus
Where
	rae.apptype is null and
	--Manage date ranges in Where.  If there are a lot of date exclusions,
	--consider using a calendar table with an exclude column, particularly
	--if the dates are structured like appdate_dte with a zero time component.   
	appdate_dte < '2012-12-01' and 
	appdate_dte > '2012-12-31'
;