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
