Re: Problems with select statement

On 1/19/06 9:55 AM, Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> wrote:

> What does something like:
> select * from
> users_to_plans p inner join
> users u using (user_id) left join
> relation_types r using (relation_type_id) left join
> languages l using (language_id)
> where p.plan_id = [some plan number here]
> order by u.relation_type_id
>
> give you?

Yay! That worked perfectly! Thank you!

I really need to read up on the different kinds of joins. I'm still not
clear on how all that works. I've done queries across multiple tables, but
only in the fairly simple form that was in my previous e-mail, which
obviously is not suitable for all situations.

The one PostgreSQL book I have ("Beginning Databases with PostgreSQL" by
Richard Stones and Neil Matthew) doesn't go into a lot of detail on them -
would you happen to know of any online tutorials about that sort of thing?

Thanks,

Lynna

--
Spider Silk Design - http://www.spidersilk.net
509 St Clair W Box 73576, Toronto ON Canada M6C 1C0
Tel 416.651.2899 - Toll Free 1.866.651.2899 - Cell 416.873.9289