SonicBase. In-memory embedded or distributed streaming sql database
SQL Right Outer Join Statement
Performs a join where all records in the right table are returned. If there is no matching record on the left then null is returned for the left side.
PreparedStatement stmt = conn.prepareStatement( "select persons.id, persons.socialsecuritynumber, memberships.personId, memberships.membershipname from persons right outer join Memberships on persons.id = Memberships.PersonId where persons.id<2 order by persons.id desc");
ResultSet ret = stmt.executeQuery();