Select Distinct Data

• jagjitsingh

  Ten Centuries

  Points: 1056

  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: 245813

  More actions

  December 9, 2021 at 3:53 pm

  Answer

  #3962088

  SELECT ItemCode from T1 UNION SELECT ItemCode from T2

  If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.