Crystal Reports Incorrect syntax near the keyword 'WITH'

Message

   I'm using VS2008 with CR Basic. I tried to add the following SQL as command under Database Expert. However, it complains about the WITH clause "Incorrect syntax near the keyword 'WITH'". I tried with the exactly same SQL using other SQL generator, it works perfectly fine. Anyone knows what the problem is?

WITH

SegmentChargeAmountByChargeTypeAndChargeCode(PassengerId, SegmentID, ChargeAmount, CurrencyCode, ChargeType, ChargeCode) as
(
    SELECT
          PJC.PassengerId, 
          PJC.SegmentID,
          PJC.ChargeAmount, PJC.CurrencyCode,            
          PJC.ChargeType, ChargeCode
    FROM PassengerJourneyCharge PJC WITH(NOLOCK)
),

-- Returns promotional discount
PromotionalDiscount(PassengerID, SegmentID, ChargeAmount) AS
(
    SELECT 
          PassengerID,
          SegmentID,
          SUM(ChargeAmount) AS ChargeAmount
    FROM SegmentChargeAmountByChargeTypeAndChargeCode
    WHERE ChargeType = 7
    GROUP BY PassengerID, SegmentID
)

SELECT IsNull(PromotionalDiscount.ChargeAmount,0) AS PromotionalDiscount
FROM Booking b (nolock)
JOIN BookingPassenger bp (nolock)--
      ON bp.BookingId = b.bookingId
JOIN BookingPassengerVersion bpv (nolock)--
      ON bp.PassengerID = bpv.PassengerID
JOIN PassengerJourneySegment pjs (nolock)--
      ON pjs.PassengerID = bp.PassengerID
JOIN dbo.Organization o (nolock)
      ON o.OrganizationCode = b.SourceOrganizationCode
LEFT JOIN PassengerJourneyCharge pjc (nolock)
      ON pjc.Passengerid = bp.Passengerid 
      AND pjc.SegmentID  = pjs.SegmentID
LEFT JOIN PromotionalDiscount
      ON PromotionalDiscount.PassengerID = bp.PassengerID
      AND PromotionalDiscount.SegmentID = pjs.SegmentID
WHERE pjc.ChargeType = 0  
pjs.SegmentSTD >= '01/15/09' 
AND pjs.SegmentSTD <= '01/17/09'