This week's book giveaway is in the Spring forum. We're giving away four copies of Pro Spring MVC with WebFlux: Web Development in Spring Framework 5 and Spring Boot 2 and have Marten Deinum & Iuliana Cosmina on-line! See this thread for details.
I have two tables (Application, Applicant). Every application can have 1 or 2 applicants. Primary key in Application (oid) is the foreign key in Applicant(app_oid). Applicants have different lastnames and SSNs. I would like to allow searching for applications based on lastname or ssn of either applicant. I would also like to do it in one sql statement. Note i need both applicants to comeback in the result set even if only one of theirs (ssn, lastname) matches the requested value.