do not use "as" in join query to name the resulting table; Oracle does not like it and PG and HSQLDB do not mind