Re: Strange Join needed...
From: Tommy Wareing <p0070621_at_brookes.ac.uk>
Date: 1 Nov 1994 18:58:06 GMT
Message-ID: <39633u$b4c_at_cs3.brookes.ac.uk>
Date: 1 Nov 1994 18:58:06 GMT
Message-ID: <39633u$b4c_at_cs3.brookes.ac.uk>
In article <1994Oct27.163142.9629_at_ivax>, msahoo_at_indyvax.iupui.edu says:
>How can I get a result more like this:
>
> A.field1 A.field2 B.field3 C.field4
> --------- --------- --------- ---------
> Smith John aaa, bbb, ccc ddd, eee
>
>This is preferred in that it will be less rows to send to my client app.
The simple answer is that you can't.
I've got a routine which does this for ReportWriter 1.1 (dunno about RW2.0).
Or it's simple enough in any 3gl (eg. pro*c)
You need to use some sort of 3gl routine which fetches all the
appropriate records from table B, and joins them together, and
then does the same thing for table C.