SonicBase. In-memory embedded or distributed streaming sql database
SQL Full Join Statement
Performs a join where all records in the left table and right table are returned even if they don't match the join criteria.
PreparedStatement stmt = conn.prepareStatement( "select persons.id, persons.socialsecuritynumber, memberships.personId, memberships.membershipname, memberships.personid from persons full outer join Memberships on persons.id = Memberships.PersonId where persons.id<2 order by persons.id desc");
ResultSet ret = stmt.executeQuery();