sub select madness
От | Tony Grant |
---|---|
Тема | sub select madness |
Дата | |
Msg-id | 1046982538.1614.43.camel@localhost обсуждение исходный текст |
Ответы |
Re: sub select madness
Re: sub select madness Re: sub select madness |
Список | pgsql-general |
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 по дате отправления: