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.


SELECT select_columns FROM table_name FULL OUTER JOIN join_table ON join_criteria
join_table:   table to join with
join_criteria:   where clause that specifies how records must match between the tables


PreparedStatement stmt = conn.prepareStatement(
    "select, persons.socialsecuritynumber, memberships.personId, memberships.membershipname, memberships.personid from persons
    full outer join Memberships on = Memberships.PersonId where<2  order by desc");

ResultSet ret = stmt.executeQuery();