4 Replies Latest reply: Nov 28, 2012 5:23 AM by Bart De Bie RSS

    Joining tables

      Hello all,

       

      How can I get the following result in QV with joining my tables?

      I have 2 tables, one contains my orders, the other table has all possible items which can be bought.

       

      Table Orders

      CustomerNoModelNoSerialNoClass
      00207R15-5AAA-1111CE
      00415R55-7BBB-2222CE
      ..................

       

      Table Models

      ModelNoClass
      R15-5CE
      R28-5CE
      R35-5CE
      R55-7CE
      R110-7WL

       

      My result to become when selecting customer 00207

      CustomerNoModelClassModelNo# Ordered
      00207CER15-51
      00207CER28-50
      00207CER35-50
      00207CER55-70
      00207WLR110-70
      Total1

       

      Current result

      CustomerNoModelClassModelNo# Ordered
      00207CER15-51
      Total1

      I just want to see all possible options in my result as well. Even if a customer has only bought 1 Model.  Anyone who can help me on this one?

       

      Thanks in advance