Postgres Pro
Downloads
Home   >   mailing lists

sub select madness - Mailing list pgsql-general

From Tony Grant
Subject sub select madness
Date
Msg-id 1046982538.1614.43.camel@localhost
Whole thread Raw
Responses Re: sub select madness  ("Carl Olivier" <carl@zero-one.co.za>)
Re: sub select madness  (greg@turnstep.com)
Re: sub select madness  (Antti Haapala <antti.haapala@iki.fi>)
List pgsql-general
Tree view 
This one is giving me a headache...

I have a list of works of art that is returned when I search on the
artists name.

I need a sub select that gets the list of expos that each work of art
has been shown at.

Can I have a sub select that shows

year, expo title, organiser, galerie
year, expo title, organiser, galerie
year, expo title, organiser, galerie
repeats as necessary

for each work using just SQL? Or do I have to call a function to get
this to work?

Hope I have been clear

Cheers

Tony Grant
--
www.tgds.net Library management software toolkit,
redhat linux on Sony Vaio C1XD,
Dreamweaver MX with Tomcat and PostgreSQL

pgsql-general by date:

Previous
From: "Magnus Naeslund(w)"
Date:
Subject: Re: GUI for postgresql
Next
From: greg@turnstep.com
Date:
Subject: Re: Sequence Of Dates ( Posting 2nd Time)