SELECT
history.historyId, defectLengths.defects, thresholdsTable.evalThresholds
FROM history
LEFT JOIN defectLengths
ON history.historyId = defectLengths.historyId
LEFT JOIN thresholdsTable
ON history.historyId = thresholdsTable.historyId;