Mike
I would say it does make sense because IN means =. So diaginfo has to
match disease character for character. Then when you use the SGET you are
saying only match the first 36 characters. Try using CONTAINS instead of IN.
Buddy
-----Original Message-----
From: MJS [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 8:21 AM
To: Rbase List
Subject: Am I doing this right?
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
