2 Replies Latest reply: Mar 10, 2015 4:35 PM by Steve Fewster RSS

    Wildcard Match via Inner Join?

    Steve Fewster

      Hi All,

       

      I have the following table of Orders.

       

      Ref               Type          Units         

      Order1          Drill               10

      Order2          CNC              20

      Order3          Drill               15

       

      I also have a table of Complete Production.

       

      Ref                Station         

      Order1           31

      Order2           41   

       

      I have some rules.

      Type               Station

      Drill                 31

      CNC               41

       

      I need to have one table as below that loads the orders, but sets the units to 0 where a valid entry for a station is found against the order.

       

      So my final table would be

      Ref               Type          Units         

      Order1          Drill               0

      Order2          CNC              0

      Order3          Drill               15

       

      I'm trying to use an inner join, with a wildcard match but not having much joy.

       

      Any help gratefully received.

       

      Thanks

       

      Steve