Home Forums SQL Server 7,2000 T-SQL Filtering shaped recordsets RE: Filtering shaped recordsets
noeld
SSC Guru
Points: 96590
More actions
May 12, 2005 at 8:29 am
#558416
SHAPE { SELECT * FROM DT_PERSON where exists (select * from DT_QUALIFICATION q where DT_PERSON.PersonID = q.Person_ID) }
APPEND({SELECT * FROM DT_QUALIFICATION} RELATE Person_ID TO Person_ID) AS ChildRS
Would something like that works?
* Noel