displaying the rows

• rs-337036

  Ten Centuries

  Points: 1105

  More actions

  January 24, 2007 at 3:37 pm

  #92956

  I have a sql query

  SELECT PropertyName, PropertyValue, UserID FROM ProfilePropertyDefinition

  INNER JOIN UserProfile ON

   ProfilePropertyDefinition.PropertyDefinitionID = UserProfile.PropertyDefinitionID

  which displays the results like this

  propertyName                      propertyValue               userid

  FirstName                                 Jon                              1

  LastName                                 Doe                             1

  CompanyName                          yahoo                           1

  FirstName                                Mark                         2

  lastName                                 doe                           2

  CompanyName                          MSN                          2

  The results i want to show are like this

  FirstName             Lastname                CompanyName   USerid

  jon                          Doe                               yahoo              1

  mark                        doe                                msn                2

  Does any 1 can help with this  

   

• January 29, 2007 at 8:00 am

  This was removed by the editor as SPAM

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  January 29, 2007 at 11:36 am

  #686220

  Cross Post

  I wasn't born stupid - I had to study.