to display row with existing

• Lucky9

  Default port

  Points: 1470

  More actions

  October 17, 2010 at 8:50 pm

  #388026

  we have 2 tables in the below format

  firsttable

  col1 col2

  1 First

  2 Second

  secondtable

  col1 col2

  first xyz

  In the report i will be displaying as

  * 1 First

  2 Second

  I have to display the records present in second table with *

  As the record with col2 first was present in second table so in the report i have to display * next to it....

• deepak.a

  SSCertifiable

  Points: 5330

  More actions

  October 18, 2010 at 4:00 am

  #1238285

  Try the Below Code

  SELECT

  CASE WHEN EXISTS(SELECT 1 FROM secondtable S WHERE S.col1 = S1.col2 ) THEN '*' ELSE '' END + CONVERT(VARCHAR,Col1) AS Col1,Col2

  FROM firsttable S1