Mike:
The logic of your command is very clear. I would not be happy trying to explain that
failure to one of our research biologists. It is clearly a bug.
My $0.02,
Jim Blackburn
Kodiak
MJS wrote:
I was looking for a concensus on wether or not to submit it to RDCC.
>
> Mike Sinclair
>
> Ben Petersen wrote:
> >
> > Mike,
> >
> > Try:
> >
> > Brow * from diaginfo t1, pasthist t2 whe t1.diagname = t2.disease
> >
> > Ben Petersen
> >
> > On 4 Jun 2001, at 8:20, MJS wrote:
> >
> > > the following does not yield any rows.....
> > >
> > > BROWSE ALL FROM diaginfo WHERE diagname IN (SELECT disease FROM
> > > pasthist)
> > >
> > > But this works...
> > >
> > > BROWSE ALL FROM diaginfo WHERE (SGET(DIAGNAME,36,1)) in (SELECT DISEASE
> > > FROM pasthist)
> > >
