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