Record | SQL Expression | SQL Type |
EH | FROM EggsAndLarvae.dbo.tblHaul INNER JOIN
EggsAndLarvae.dbo.tblHaulData ON EggsAndLarvae.dbo.tblHaul.tblHaulID = EggsAndLarvae.dbo.tblHaulData.tblHaulID INNER JOIN
REH ON EggsAndLarvae.dbo.tblHaulData.Value = REH.NationalHaulID
where tbluploadID not in (
SELECT tblUploadID
FROM REH INNER JOIN
EggsAndLarvae.dbo.vw_EH_Record ON isnull(REH.Institute,'') = isnull(EggsAndLarvae.dbo.vw_EH_Record.Institute,'') AND REH.Survey = EggsAndLarvae.dbo.vw_EH_Record.Survey AND
REH.Country = EggsAndLarvae.dbo.vw_EH_Record.Country AND REH.Year = EggsAndLarvae.dbo.vw_EH_Record.Year AND REH.Ship = EggsAndLarvae.dbo.vw_EH_Record.Ship
group by tblUploadID ) | Free SQL |