stupid select question...

From: Konstantinos Agouros <elwood(at)agouros(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: stupid select question...
Date: 2001-01-14 10:57:40
Message-ID: 20010114115740.B8902@rumba.agouros.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

my sql has gotten a little rusty, here's what I want to do:
I have two tables both contain urls. How what I want are all the entries in
table b where there is no matching url in table a. I do remember doing something
like this with a
select url from table1 where a.url not in select url from table b.

Can I do this in postgres?

Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood(at)agouros(dot)de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres

Browse pgsql-general by date

  From Date Subject
Next Message Lark 2001-01-14 11:04:56 Does PostgreSQL support Dynamic SQL?
Previous Message Dan Langille 2001-01-14 10:27:06 getting number of rows updated within a procedure