Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT bad.agent as Agents,
- dog.SUPPLIER as SUPPLIER,
- bad.status as TheStatus,
- country.analysis_master1 as Country,
- ftb.booking_actual_retail as BookingActualRetail,
- ftb.Booking_Actual_Cost as BookingCost,
- ftb.Booking_Actual_Retail_inc as BookingRetailINC,
- fts.Service_Id,
- fts.Service_Actual_Retail_inc as ServiceActualCostInc,
- Product.SERVICE,
- Product.SL_STATUS as SLSTATUS,
- cat.name as Product2,
- bad.LAST_SERVICE_DATE as Servicedate,
- bad.LW_DATE as LWDATE,
- ftb.Entered_Date as DATEENTERED,
- ftb.Booking_Pax as PEOPLE,
- ftb.Booking_Children as KIDS,
- bad.TRAVELDATE as TRAVELDATE,
- bad.FULL_REFERENCE
- from BHD bad
- inner join FTB on bad.FULL_REFERENCE = ftb.booking_reference
- inner join FTS on FTB.Booking_Id = fts.Booking_Id
- inner join DRM Country on bad.agent = country.code
- inner join BSL Product on bad.BHD_ID = Product.BHD_ID
- inner join SRV cat on Product.SERVICE = cat.CODE
- inner join OPT dog on Product.OPT_ID = dog.OPT_ID
- where bad.STATUS = 'IV' AND bad.FULL_REFERENCE = 'LTIT129488'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement