Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!cs.utexas.edu!uunet!lsicom2!root
From: root@lsicom2.UU.NET (Admin)
Newsgroups: comp.databases
Subject: Re: SQL Question
Keywords: SQL
Message-ID: <1090@lsicom2.UU.NET>
Date: 5 Oct 90 14:16:38 GMT
References: <391@ulticorp.UUCP>
Organization: LSI Communications
Lines: 28

mikei@ulticorp.UUCP (mikei) writes:

>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

>.


This isn't specifically Gupta........


select PID from table
where not exists
	(select PID from table
	where WEIGHT > 100)