displaying Columns through select

• SQLTestUser

  Hall of Fame

  Points: 3997

  More actions

  June 12, 2013 at 11:26 am

  #295166

  I have three tables

  A ID, A.name, A.LastName

  B ID, B.Name,B.someothername

  C ID, C.why,C.whyalso

  all connected by ID's

  i have a query as below to get the data

  select A.Name,B.name,C.Why

  where A.ID = B.ID

  and C.ID = A.ID

  however i need the select in a way that if there are null values we show them as A.name is null or b.name is null i.e if A.name is null select A.Name as "A'S is NULL"

  how do i implement this logic in a select statement

  thanks

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  June 12, 2013 at 11:57 am

  #1623458

  Like this?

  select isnull(A.Name, 'A is null') as AName, isnull(B.name, 'B is null') as BName, C.Why

  where A.ID = B.ID

  and C.ID = A.ID

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/