Re: SQL Question - Mailing list pgsql-novice

From Francisco Reyes
Subject Re: SQL Question
Date
Msg-id 20011110143044.U37050-100000@zoraida.natserv.net
Whole thread Raw
In response to SQL Question  (Brian <Brrrian@Excite.com>)
Responses join question
List 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.


pgsql-novice by date:

Previous
From: "Luz Lopez"
Date:
Subject: Query very slow
Next
From: Francisco Reyes
Date:
Subject: Re: Query very slow