The PostgreSQL docs are unfortunately scarce on JOINshttp://www.postgresql.org/docs/8.4/static/tutorial-join.html
I've never seen a JOIN producing several rows insteadof columns before Michael suggested it in this thread