Record | SQL Expression | SQL Type |
EH | FROM EggsAndLarvae.dbo.tblHaul INNER JOIN
EggsAndLarvae.dbo.tblHaulCodeRel ON EggsAndLarvae.dbo.tblHaul.tblHaulID = EggsAndLarvae.dbo.tblHaulCodeRel.tblHaulID INNER JOIN
EggsAndLarvae.dbo.tblCode AS Ship ON EggsAndLarvae.dbo.tblHaulCodeRel.tblCodeID = Ship.tblCodeID INNER JOIN REH ON Ship.Code = REH.Ship AND EggsAndLarvae.dbo.tblHaul.intday = REH.Day AND EggsAndLarvae.dbo.tblHaul.intmonth = REH.Month AND
EggsAndLarvae.dbo.tblHaul.intyear = REH.Year
where Ship.tblCodeGroupID = 197 and REH.Ship not in ('AA36','ZZ99') and 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 |