Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!ulticorp!mikei
From: mikei@ulticorp.UUCP (mikei)
Newsgroups: comp.databases
Subject: SQL Question
Keywords: SQL
Message-ID: <391@ulticorp.UUCP>
Date: 4 Oct 90 19:29:56 GMT
Organization: The Ultimate Corp., East Hanover, NJ
Lines: 17

Greetings,

Perhaps there is an SQL guru out there who can be of some assistance.
Note I am using GUPTA's SQLBase.

Given a table of patients PID int   WEIGHT int
where one PID may have numerous weight readings.

How would I select the PID for only those patients whose
weight was ALWAYS <= 100.

ANy ideas would be appreciated.  


                                        uunet!ulticorp!mikei

.