sql query

• Swetha527

  Old Hand

  Points: 300

  More actions

  July 18, 2012 at 11:23 pm

  #259097

  CREATE TABLE [dbo].[Trans1](

  [RPTTypeCode] [char](2) NULL,

  [Firstname] [varchar](50) NULL,

  [LastName] [varchar](50) NULL,

  [BarrowerID] [int] NULL,

  [LoanTransID] [int] NULL

  ) ON [PRIMARY]

  insert into [Trans1] values('B1','Swathi','B',10,1),('C1','Anu','CH',11,1),('E1','Chintu','KK',13,1)

  CREATE TABLE [dbo].[Trans2](

  [LoanAppID] [int] NULL,

  [LoanTransID] [int] NULL,

  [LoanNumber] [varchar](10) NULL

  ) ON [PRIMARY]

  insert into [Trans2] values(1,1,'ABC123')

  I want query output as below in sinlge row.

  LoanNumber, B1.FirstName, B1.LastName,C1.FirstName,C1.LastName,E1.FirstName,E2.LastName

  I do not want to hardcode "RPTTypeCode" column values because sometimes i get more values in the RPTTypeCode column of Trans1 table.

  Anybody can help me please???

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  July 18, 2012 at 11:41 pm

  #1514607

  Post replies here.

  Please do not post multiple times.

• vijayarani87.s

  SSC Eights!

  Points: 890

  More actions

  July 19, 2012 at 1:36 am

  #1514646

  Can u please tell the exact scenario, Do u need to show all the entries in trans1 table in single row with the loan Number?