Re: SQL Question

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Brian <Brrrian(at)Excite(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL Question
Date: 2001-11-10 19:42:42
Message-ID: 20011110143044.U37050-100000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Sat, 10 Nov 2001, Brian wrote:

> A SQL Question...
> I am trying to query table1, selecting records that do NOT have a relation in a subset from table3 that is related to table2.

You lost me there.

> if I choose some magician I want a list of tricks he/she DOES-NOT know.

You basically want an outer join.
I am sort of a newbie on SQL so I am not sure on the syntax.
Will try to see if I can send you an example later.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Francisco Reyes 2001-11-10 19:45:33 Re: Query very slow
Previous Message Zetta Delaney 2001-11-10 19:40:32 question for you