combine query

• pietlinden

  SSC Guru

  Points: 63621

  More actions

  July 24, 2017 at 8:42 pm

  #1952487

  Use OR/IN in the your WHERE clause.

  SELECT itemno,item code,closedate
FROM item a INNER JOIN itemcode bFROM item a INNER JOIN itemcode b
ON a.itemno= b.itemnoON a.itemno= b.itemno
WHERE  a.itemdesc IN *('approve', 'in progress', 'received');WHERE  a.itemdesc IN *('approve', 'in progress', 'received');

• coool_sweet

  SSCommitted

  Points: 1892

  More actions

  July 25, 2017 at 7:59 am

  #1952562

  I want something liekt his

  SELECT itemno,item code,closedate as new_date(in progress),close_date for open_date(approve)
  FROM item a INNER JOIN itemcode bFROM item a INNER JOIN itemcode b
  ON a.itemno= b.itemnoON a.itemno= b.itemno
  WHERE  a.itemdesc IN *('approve', 'in progress', 'received');WHERE  a.itemdesc IN *('approve', 'in progress', 'received');

   

• pietlinden

  SSC Guru

  Points: 63621

  More actions

  July 25, 2017 at 11:51 pm

  #1952708

  Why not make things easy for everyone and tell us all what your expected output is given the data you have already provided?

• Chris Harshman

  SSC-Forever

  Points: 42192

  More actions

  July 26, 2017 at 8:37 am

  #1952790

  maybe something like:
  SELECT a.itemno, b.itemcode,
    CASE a.itemdesc
    WHEN 'aprove' THEN a.closedate
    WHEN 'inprogress' THEN a.opendate
    WHEN 'reject' THEN a.eventdate
    END AS evemtdate
  FROM item a
  INNER JOIN itemcode b ON a.itemno = b.itemno
  WHERE a.itemdesc IN ('aprove', 'inprogress', 'reject')