4 Replies Latest reply: Aug 27, 2012 3:31 PM by diego rueda encinales RSS

    how to load from more tables

    steve peroni

      Hi,

      I'm a beginner and I'm working with the Personal edition. I've two tables for car rent:

       

      table1

      CARCODE          RENT PERIOD               CUSTOMER

      C1                       20-07-11  -   25-07-11     C 

      C1                       01-06-12  -   07-06-12     A

      C2                       22-06-12  -   23-06-12     B

      C3                       25-06-12      28-06-12      A

          

      table2

      CARCODE              ACTIVE PERIOD

      C1                         01 - 01- 11   /  31 -12- 11

      C1                         01 - 01- 12  /  31 - 12 - 12    

      C2                         01 - 04 - 12  /  31 - 12 - 12

      C3                         01- 06-  12   /  31- 12 - 12                              

       

      I would have one table with all the information concerning 2012, like this:

       

      CARCODE          RENT PERIOD               CUSTOMER   ACTIVE PERIOD

      C1                       01-06-12  -   07-06-12     A                   01 - 01- 12   31- 12- 12

      C2                       22-06-12  -   23-06-12     B                   01 - 04- 12   31- 12- 12

      C3                       25-06-12      28-06-12      A                  01 - 06- 12   31- 12- 12

       

       

      How can I arrange this table ?

      Help please 

       

      Thanks !!

      Gr.