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 :)