Re: correlated subqueries (response)
Date: 11 Feb 1993 14:53:12 GMT
Message-ID: <1ldp8o$59u_at_gazette.bcm.tmc.edu>
In article <1993Feb11.072322.8346_at_wlbr.iipo.gtegsc.com>, sievert_at_wlonex.iipo.gtegsc.com (Glen Sievertson) writes:
> Tom tried it using VAX RDB:
>
> and got the following results:
>
> >
> > YR
> > 1985 445 456 501
> > 1985 445 456 501
> > 1985 445 456 501
> > 1986 517 589 605
> > 1986 517 589 605
> > 1986 517 589 605
> > 1987 606 613 822
> > 1987 606 613 822
> > 1987 606 613 822
> >9 rows selected
Wellllll, sheeeeeeeet! I'm using Sybase and recreate Tom's output . . .
Do you want the multiple/identical rows returned, or not?
If not, since each of the duplicate rows are, in fact, exact duplicates you could put the keyword 'distinct' right after the word 'select'. Has anyone tried grouping the results????
Or is the question here to explain why different RDBMSs return different results? :-(
OK . . . so it's only worth $0.01 this time . . .
Mark Received on Thu Feb 11 1993 - 15:53:12 CET