Re: Strange Join needed...

In article b4c_at_cs3.brookes.ac.uk, p0070621_at_brookes.ac.uk (Tommy Wareing) writes:
>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.
>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.
>
>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)

Hi!

I haven't installed 7.1 yet, but one of its features is supposedly to allow user functions in SQL statements. Your "Strange Join" is one of the applications I had in mind, as well as recursive functions that could build a millitary style number (ie 1.2.2.3 ) which can't be done in a connect by join.

I hope this helps, and I hope it works when I go to use it ;-}.

Happy computing!

Sincerely,

Martin Farber
Independent Oracle Consultant "A Jack of all trades and a slave to one."

                        |  NYNEX Science & Technology
                        |  500 Westchester Ave, Rm 1B-23
                        |  White Plains, NY  10604
                        |     -----------------
                        |  email: farber_at_nynexst.com
                        |  Voice: 914/644-2656
                        |    FAX: 914/644-2216