Easiest way to extract owner-id from a third table

Поиск
Список
Период
Сортировка
От Rikard Bosnjakovic
Тема Easiest way to extract owner-id from a third table
Дата
Msg-id AANLkTimmNktgB1zyWpa+BQdqXXTQE-dURmEs=3UxPfw+@mail.gmail.com
обсуждение исходный текст
Ответы Re: Easiest way to extract owner-id from a third table  (Thom Brown <thom@linux.com>)
Список pgsql-novice
I have four tables:

users (id, name, ...);
components (id, owner_id (references users), ...);
images (id, filename);
component_images (id, components_id (references components), images_id
(references images));

This way, I can have unlimited amount of images per component.

Now I'm looking for a way to extract the owner-id (that's specified in
the components table) and the owner name while having only the
image_id at hand. I can ofcourse first select a row in
component_images and - in the application - extract the value for
components_id. Then I can use another query to find the owner id in
the components table, which will let me have the owner id.

Is there a way to achive all this without having to fiddle around in
the application? I haven't got the faintest idea of how to specify
this query.


--
- Rikard

В списке pgsql-novice по дате отправления:

Предыдущее
От: Brad Nicholson
Дата:
Сообщение: Re: Performance monitoring?
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Easiest way to extract owner-id from a third table