Retrieving columns from related tables

• logzyy

  SSC Rookie

  Points: 43

  More actions

  October 21, 2010 at 10:28 am

  #225305

  Hi everyone,

  I have a design like the one attached to this post and i want to be able to query the tiers table and return the name field from the 3 tables related to tiers.

  I want the the firstname and lastname in Person concatenated to name

  In the end i want something like this

  TierId NAME

  1 Gabriel G

  2 Microsoft

  3 My group

  Thank you

• SQLTestUser

  Hall of Fame

  Points: 3997

  More actions

  October 21, 2010 at 11:17 am

  #1240477

  Would something like this work for you

  Select Concat ( firstName,LastName) OR Select firstName|| ' ' || LastName

  Into A.Name

  FRom Table A A Inner JOIN TableB B

  where A.ID = B.ID

• logzyy

  SSC Rookie

  Points: 43

  More actions

  October 22, 2010 at 9:35 am

  #1241013

  Thanks SQLTestUser. I'd try it out and let you know

• logzyy

  SSC Rookie

  Points: 43

  More actions

  October 23, 2010 at 4:12 am

  #1241258

  I get the code you have pasted but that really isn't what i want.

  The three tables related to tiers have somethings in common, the name field except for Persons that has firstname and lastname. I want to pull data from all the three tables along with the named field