I am performing a HQL(Hibernate 5.2) join of 3 tables where no association mapping between these 3 tables is present. However table 3 has an optional association to table 4.
Due to this null value column for fk(table4) in table 3 , those rows get skipped in the resultset. How can I ensure the result set includes all rows of the join with null values also. Table 3 has data in all columns except the association to table 4 .
Expected all rows which match the filter condition with null for few columns.