Re: SRW v 1.1 question--can parent data be suppressed if no child data exists?
From: Lawrence James <james.lawrence_at_epamail.epa.gov>
Date: 1996/01/17
Message-ID: <james.lawrence.138.000F9146_at_epamail.epa.gov>#1/1
Date: 1996/01/17
Message-ID: <james.lawrence.138.000F9146_at_epamail.epa.gov>#1/1
In article <4d0nct$ibu_at_niven.ksc.nasa.gov> "susan g. dahl" <dahls_at_rockwell.ksc.nasa.gov> writes:
>From: "susan g. dahl" <dahls_at_rockwell.ksc.nasa.gov>
>Subject: SRW v 1.1 question--can parent data be suppressed if no child data exists?
>Date: 10 Jan 1996 15:53:01 GMT
>Is there a way to do this without user exits? I actually have 3 child
>queries for the same parent query. If none of them find anything then I
>do not want to print the parent entry either...
>TIA, Susan Dahl
I suspect there may be a way within RW to do this. But a quick trick would be to put sub-queries in the where clause of your parent so that no rows are returned if no related rows exist.
Lawrence...... Received on Wed Jan 17 1996 - 00:00:00 CET