Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group