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
> >
> >
