tblUserProperty

Vote:
 
Hi. Has anyone any tips or a sample on how to select userdata from tblUserProperty in a horizontal structure? I need to create an SQL which displays the userdata from tblUser and tblUserProperty, for exporting to another system. Typically, the data need to look like this: UserName FirstName LastName Property1 Property2 Property3 the first 3 fields are from tblUser, and the PropertyX fields are from tblUserProperty. Frank :)
#12239
Mar 11, 2005 10:40
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.