eXtremeSQL supports
right
andfull outer
joins which are implemented using a hash join algorithm, where the inner (right) table is materialized in a hash table.An example of
full outer
join queries can be found insamples/xsql/scripts/full_join.sql