11 Replies Latest reply: Feb 12, 2016 5:17 AM by fredrik olsson RSS

    Conditions over multiple rows

    fredrik olsson

      Hi,

       

      I have two tables and I wanna have a list of all orders that contain 2 specific products, in this case I wanna have all orders that bought both a phone (175) and a headset (189). Any ideas how to solve this in a easy way? Thanks

       

      Table Order:

      OrderIdTotalMisc
      1001500Misc1
      1002300Misc2

       

      Table Product:

      OrderIdProductIdNamePrice
      1001175Phone400
      1001189Headset100
      1002554Charger300