Mike,
These are just two different select methods, so I'd expect both to
succeed if one does.
Ben Petersen
On 4 Jun 2001, at 12:03, MJS wrote:
> Your way works just fine...it appears that the problem only effects the
> subselect method. I was looking for a concensus on wether or not to
> submit it to RDCC. It's not a big problem, and I'm not sure if it
> qualifies as a bug, but it seems to me like both ways should work.
>
> 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:
> >
> > > I have 2 tables, 1 column each (not really, but it simplifies my
> > > question). Table 1 is called diaginfo and it's column is called
> > > diagname (TEXT 50).
> > > Table 2 is called pasthist and it's column is called disease (TEXT 36).
> > >
> > > Most of the data does not fill the whole column. In Rbase for Windows,
> > > 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)
> > >
> > > Does this make sense?
> > >
> > > TIA!
> > >
> > > Mike Sinclair
> > >
> > >
>
>
