Is full outer join supported? Is full outer join supported? Guest (visitor) (OP) 9 Aug 02 04:09 Is FULL OUTER JOIN supported in Mimer? RE: Is full outer join supported? petersJazz (Programmer) 9 Aug 02 04:15 Dont think full outer join is standard SQL. It is not supported in Mimer, you have to write like this to get a search where all rows are retrieved:select ...from table1 right outer join table2 using (id)unionselect ...from table1 left outer join table2 using (id);Union without "union all" is not that efficient. A sort and merge is required.