Home Forums SQL Server 2017 SQL Server 2017 - Development Combine 3 SQL queries RE: Combine 3 SQL queries
pietlinden
SSC Guru
Points: 63434
More actions
November 19, 2017 at 6:31 am
#1968668
Sounds like you need something like(Kid LEFT JOIN Suggestions) LEFT JOIN Complaints
But then you'd need KidID in Suggestions AND in Complaints. Otherwise, how do you know which "kid" record is related to the Suggestion/Complaint record?