9 Replies Latest reply: Dec 22, 2017 10:35 AM by Rupesh Shelar RSS

    Joins condtions

    Rupesh Shelar

      Table1:

       

      Stringjob type
      23coil tubiing1
      24Hint1
      26

      Hint2

       

       

      Table2

       

       

      Stringjob typejob type3job type2Sales
      23coil tubiing1coil tubiing1coil tubiing35000
      24HintHint1Hint210000
      26DrillingDrilling2Drilling320000

       

       

      how to join  jobtype in such a way so that we can get all jobtype1,jobtype2,jobtype3 into one column

      like

      string  jobtype

      23       Coli tubing1

      23           Coil tubing2

      23           Coil tubing3

      l

      in a way convert rows in columns and get only one sales value