To send Confirmed PAX ticket which are inbound to FCO(Rome ITALY).Use the below query
WITH TEMP AS
(
SELECT DISTINCT
A.PNR_Locator
,A.PrimaryDocNbr
,A.HomeCityCode
,A.PointOfTktIssuance
,A.CustomerFullName
,B.ServiceStartCity
,B.ServiceEndCity
--,PassengeType
,B.CouponStatus
,B.ServiceStartDate
FROM [CDDTKTING].[dbo].[TktDocument] A JOIN [CDDTKTING].[dbo].[TktCoupon] B
ON A.PNR_Locator=B.PNR_Locator
AND A.PNR_Create_Date=B.PNR_Create_Date
AND A.PrimaryDocNbr=B.PrimaryDocNbr
AND A.VCRCreateDate=B.VCRCreateDate
AND A.[PNR_Create_Date]=B.[PNR_Create_Date]
where
B.ServiceStartCity='ADD'
and B.ServiceEndCity='FCO'
and B.ServiceStartDate='2018-02-01'
)
Select
distinct
T.*
,R.[Issue_Country_Code]
,R.[Document_Number]
FROM [CDDTKTING].[dbo].[ResPaxDoc] R RIGHT JOIN TEMP T
on R.PNR_Locator=T.[PNR_Locator]
ORDER BY ServiceStartDate ASC