13 Replies Latest reply: Feb 17, 2017 2:00 PM by fredrik olsson RSS

    Table field relation in load statement

    fredrik olsson



      I'm trying to use a related field in the where clause of my load statement, but if fails.



          Booking AS BookingId,

          Destination AS BookingDestination;



          IATA as BookingDestination,

          ContinentCode as BookingContinentCode;


      The following WHERE clause later in the load statement fails becuase "BookingContinentCode"  is unkown:

      WHERE BookingId = 2134 AND BookingContinentCode = 'EU';


      Any help are appreciated!