:: RCL ::

Query : SELECT distinct a.portcall, c.LocName FROM tvoymast a(NOLOCK index=A5TVoyMast), tvoymastext b(NOLOCK), tlocmast c(NOLOCK) WHERE a.etddate >= '24 Apr 2018' AND a.etddate < dateadd(month,1,'24 Apr 2018') AND a.portcall = b.portcall AND a.vslcode = b.vslcode AND a.outvoyno = b.outvoyno AND substring(b.svccode,1,3) = 'RBC' AND a.portcall = c.LocCode and a.portcall not like 'IR%' Order By a.portcall

Please select appropriate values and click Get Schedule
Service Name	:
Your Port::	:
Duration	:	1 month(s) 2 month(s) 3 month(s)
From	:

� 2004 Regional Container Lines. All rights reserved.