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