rpinder@phad.hsc.usc.edu (Rich Pinder) (06/08/90)
Is the OUTER JOIN supported in:
Accell/Unify 2000
Informix Turbo
??
Thanks,
Rich Pinder
USC School of Medicine
(213) 224-7099
rpinder@phad.hsc.usc.edu
||||||||||||||||||||||||||||||||||||||||||||||||||ron@rdk386.uucp (Ron Kuris) (06/12/90)
In article <25175@usc.edu> rpinder@phad.hsc.usc.edu (Rich Pinder) writes: >Is the OUTER JOIN supported in: > > Accell/Unify 2000 > Informix Turbo > > ?? Don't know about Informix, but it is supported in Unify 2000's SQL. -- -- ...!pyramid!unify!rdk386!ron -or- ...!ames!pacbell!sactoh0!siva!rdk386!ron It's not how many mistakes you make, its how quickly you recover from them.
ron@rdk386.uucp (Ron Kuris) (06/13/90)
In article <25175@usc.edu> rpinder@phad.hsc.usc.edu (Rich Pinder) writes: >Is the OUTER JOIN supported in: > > Accell/Unify 2000 > Informix Turbo > > ?? > >Thanks, Sorry, U2000 does *NOT* support OUTER joins, contrary to whatever I said before. I probably didn't get much sleep and missed the OUTER (how blind I am...) I guess my signature says it all... -- -- ...!pyramid!unify!rdk386!ron -or- ...!ames!pacbell!sactoh0!siva!rdk386!ron It's not how many mistakes you make, its how quickly you recover from them.
bochner@flare.harvard.EDU (Harry Bochner) (06/13/90)
In article <25175@usc.edu> rpinder@phad.hsc.usc.edu (Rich Pinder) writes: >Is the OUTER JOIN supported in: > > Accell/Unify 2000 > Informix Turbo > > ?? It's supported in plain Informix (ISQL, 4GL), so I would assume it's supported in the Turbo version as well. Harry Bochner bochner@endor.harvard.edu
rdg@virtech.uucp (Roger D. Gough) (06/13/90)
In article <1990Jun11..23203@rdk386.uucp>, ron@rdk386.uucp (Ron Kuris) writes: > In article <25175@usc.edu> rpinder@phad.hsc.usc.edu (Rich Pinder) writes: > >Is the OUTER JOIN supported in: > > > > Accell/Unify 2000 > > Informix Turbo > > > > ?? > > Don't know about Informix, but it is supported in Unify 2000's SQL. > Informix, too. Just out OUTER after each 'outer' table in the FROM clause. -- Roger D. Gough +1 703 689 1692 Sequel Technologies uunet!sequel!rdg
aland@infmx.UUCP (Colonel Panic) (06/14/90)
In article <3188@husc6.harvard.edu> bochner@flare.harvard.EDU (Harry Bochner) writes: >In article <25175@usc.edu> rpinder@phad.hsc.usc.edu (Rich Pinder) writes: >>Is the OUTER JOIN supported in: >> Accell/Unify 2000 >> Informix Turbo > >It's supported in plain Informix (ISQL, 4GL), so I would assume it's supported >in the Turbo version as well. Outer join has been supported in all Informix SQL engines (SE, Turbo, OnLine) since at least version 2.00.00 (1985?). -- Alan Denney # Informix # aland@informix.com # {pyramid|uunet}!infmx!aland "Out on the highway doing 98... radio's blastin', and he's tempting fate He swears he saw an angel in a black Corvette She was blowing him kisses through her cigarette [Was (Not Was)] Boy's gone crazy; it's not just a phase, he's one step over the line..."
dag@fciva.FRANKLIN.COM (Daniel A. Graifer) (08/29/90)
I am trying to add the following capability to an existing Unify 4 database, (but I think the question is valid in any implementation). The existing database contains a table of items identified by an itemkey. I want to add the ability to generate reports with items subtotaled in sets contained in the database. We should be able to store several such groups of item-sets. TABLE items itemkey * STRING 6 . . . TABLE rptgrp grpname * STRING 6 grpdesc STRING 20 TABLE rptset setkey * COMB setname STRING 6 part of setkey ofgrp Ref to grpname part of setkey setdesc STRING 20 TABLE item2grp /* Case 1 */ i2gkey * COMB item Ref to itemkey part of i2gkey set Ref to setkey part of i2gkey TABLE item2grp /* Case 2 */ i2gkey * COMB item Ref to itemkey part of i2gkey grp Ref to grpname part of i2gkey set Ref to setname The first case doesn't correctly express the relationship: Items must be uniquely assigned within each group. Case 1 would permit the assignment of an item to two sets within the same group. The second case permits an item to be assigned to a non-existant set/group combination, ie one which doesn't occur in rptset. One way of presenting the question is relative to Case 1: How do I make a subfield of the combined field 'set' part of the unique key for item2grp? Any help greatly appreciated. Dan P.S. Reply to uunet.uu.net!fciva!dag. My newsposter is editting my .signature file into garbage! -- Daniel A. Graifer Franklin Mortgage Capital Corporation uunet!dag@fmccva.franklin.com 7900 Westpark Drive, Suite A130 (703)448-3300 McLean, VA 22102