12 Replies Latest reply: Mar 4, 2011 3:28 PM by Muncho Ts RSS

    How to join this table?

      Hi all im totally new in QV.

      Well i have 2 table. I need to join them.
      tables are

       


      table1:
      load * inline [
      country, express
      AT, 2
      DK, 2
      GB, 3
      GR, 4
      ....
      ];
      table2:
      load * inline [
      weight, zone1, zone2, zone3
      0.5, 6, 8, 10
      1, 7, 9, 11
      1.5, 8, 10, 12
      2, 10, 12, 14
      .....
      ];


      table1 contains country and their zone codes.
      table 2 contains costs of zones and weights.

      I need to match zones and join them. How to do this? Need some help please.