Here's one more for you

select * FROM PARENT p
	JOIN (SELECT distinct PK_FLD FROM CHILD WHERE(&cChildFilter)) dt1
		ON dt1.PK_fld = p.PK_fld 

>Thank you, Sergey. By the way, did you look at the correction of my second subquery posted by Bob Flanagan? Was his subquery a better approach?