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: (view raw or whole 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.


table1(Trick table)

table2(Magician table)

table3(Trick-Magician-Knows table)

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

thanks for any insight !


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-2015 The PostgreSQL Global Development Group