ICES Marine Data
DATSU > List of operations > Specification of the format > Details of the check

Details of a check:
Record: EC
Check Description: This CampaignID was already used by another organization, please use another one.
Error type: error

RecordSQL ExpressionSQL Type
ECFROM REC INNER JOIN RFI ON REC.SessionID = RFI.SessionID INNER JOIN (SELECT DataRightsHolder, CampaignID FROM ESAS.dbo.vw_campaign) AS DB ON REC.CampaignID = DB.CampaignID where RFI.DataRightsHolder <> DB.DataRightsHolder Free SQL

International Council for the Exploration of the Sea (ICES) · Conseil International pour l'Exploration de la Mer (CIEM)
ICES Secretariat · H. C. Andersens Boulevard 44-46, DK 1553, Copenhagen Denmark · Tel: +45 3338 6700 · Fax: +45 3393 4215 ·
Disclaimer © ICES - All Rights Reserved