Select Distinct Data

• jagjitsingh

  Ten Centuries

  Points: 1059

  More actions

  December 9, 2021 at 3:50 pm

  Go to Answer

  #3962085

  Hi

  I have 2 tables with Item Code . I want to select distinct itemcode from 2 tables

  ItemCode                               ItemCode

  a                                                    a

  b                                                     c

  Output should be

  a

  b

  c

   

  Thanks

   

• Phil Parkin

  SSC Guru

  Points: 246962

  More actions

  December 9, 2021 at 3:53 pm

  Answer

  #3962088

  SELECT ItemCode from T1 UNION SELECT ItemCode from T2

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin