SQL Question

From: Brian <Brrrian(at)Excite(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: SQL Question
Date: 2001-11-10 18:26:58
Message-ID: 3.0.5.32.20011110102658.00960100@pop.we.mediaone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

A SQL Question...

Bear with me... I'm kinda new here.

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

Example:

table1(Trick table)
1_id,trickName,trickDescription

table2(Magician table)
2_id,lastName,firstName

table3(Trick-Magician-Knows table)
2_id,1_id

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

thanks for any insight !

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Luz Lopez 2001-11-10 18:52:49 Query very slow
Previous Message Francisco Reyes 2001-11-10 18:23:37 Re: Different results based on number of records out of