fixes multiple join syntax (not tested yet).
Fixes one row query that works with Oracle.