| 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 20:18:57 |
| Message-ID: | 20011110151635.F37050-100000@zoraida.natserv.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Sat, 10 Nov 2001, Brian wrote:
>
> I am trying to query table1, selecting records that do NOT have a relation in a subset from table3 that is related to table2.
I tried, but couldn't figure it out.
I think the solutions is along these lines:
-Make a query which will return the combination of all names and tricks.
Something like "select tricks.trick, names,name from tricks,names;"
-Store the result of the query above into a table
-Do an outer join of tricks and the "complete" table for the instances
where the name is null.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brett W. McCoy | 2001-11-10 20:39:59 | Re: Sending query to a file |
| Previous Message | Francisco Reyes | 2001-11-10 19:45:33 | Re: Query very slow |