Re: [SQL] locked my keys in the car

From: "Phil R Lawrence" <prl2(at)lehigh(dot)edu>
To: <ugd(at)geeky1(dot)ebtech(dot)net>, <pgsql-sql(at)postgreSQL(dot)org>
Cc: "UserGuideDog" <ugd(at)geeky1(dot)ebtech(dot)net>
Subject: Re: [SQL] locked my keys in the car
Date: 1998-08-03 17:43:24
Message-ID: 009401bdbf06$37fd5460$3e03b480@dummy.res.lehigh.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>So my next question is:
>Is there a way, using SQL, to do the math on this, i.e., to rm the
>patients who appear twice - once in the first query, once in the second?
>(God forbid we re-admit the same patient at some future date!)

Try MINUS.

SQL1
MINUS
SQL2

yields SQL1's results minus any also found in SQL2.

Browse pgsql-sql by date

  From Date Subject
Next Message All Of Us 1998-08-03 17:55:23 password protection
Previous Message James Olin Oden 1998-08-03 17:35:17 Re: [SQL] can a column be aliased?