3 Replies Latest reply: Jun 7, 2012 7:21 AM by Joe Kirwan RSS

    Condition in Join

    Joe Kirwan

      Hi

       

      I have a Trans table

       

      MonthInvNoItemVal
      Jan1A10
      Jan2B20
      Feb3A15

       

      I have a Rate table

       

      MonthRate
      Jan0.7
      Feb0.8

       

      I am trying to join the Rate field in the Rate table to the Trans table for Item equal A.

       

      I have tried this code:

       

      LEFT Join (Trans)

      LOAD IMonth,

      Rate

       

      Resident Rate

      where Item='A'

       

      but this doesn't seem to work.

       

      Any ideas?