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