Custom SQL Query: LEFT OUTER JOIN, not joining properly? | JMP 15
Hello,I'm trying to join WeeklyDOSummary (yellow) and PondMaster_Investigations (green). I've highlighted the columns selected on my custom SQL query.From WeeklyDOSummary, I am left outer joining PondMaster_Investigations on date = date and pond = pond. Although you can't see it clearly in the photos, there are data in the Ave and NO23 columns where there are common dates (ranging from 05/07/2020 ...