| Record | SQL Expression | SQL Type |
| EH | FROM REH INNER JOIN
EggsAndLarvae.dbo.vw_EH_Record ON ISNULL(REH.Institute, N'a.b.c.d.e') = ISNULL(EggsAndLarvae.dbo.vw_EH_Record.Institute, N'a.b.c.d.e') 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
where REH.LineNumber = 1
group by SessionID , REH.LineNumber | Free SQL |
