I did not realize that on my brithday PostgreSQL hit 9.3 mark (see a news). With this release there is a new join type that I first hear about. It is named LATERAL JOIN. There is no need for me to copy the documentation, so if you want to know what that is head to the Postgres page.
But for those of you who do not want to go there. Simply speaking lateral join is a join between a table and a table from a second subquery.