Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SHAPE recordsets with no child

Status
Not open for further replies.

dicesare

Programmer
Nov 30, 2001
8
IT
Hi all! Does anyone know a method to instruct SHAPE to not return parents
recordsets that do not have child recordset?

for example, using the following

SHAPE {SELECT * FROM publishers} APPEND
({SELECT * FROM titles} AS PubTitles
RELATE pub_id TO pub_id)

if a Publisher doesn't have any Titles related, that record should not
appear in the returned recordset.

TIA



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top