PostgresでJOIN構文
http://osb.sra.co.jp/PostgreSQL/Manual/PostgreSQL-7.1-ja/explicit-joins.html
例)
select * from [table_name],[table_name2] where [table_name].[COLUMN] = [table_name2].[COLUMN] ;
↓こんな感じ。
select * from user,school where user.school_id = school.id ;