SQL to retrieve from two tables
I am creating a web site using ASP.NET. I have a login function working with the generic aspnetdb.mdf which works with the user profile wizard. I have been able to populate a grid with information based on the user who is logged in; for example the User name and ID number. I want to bring data from another table, (with a view to joining the generic database to my own database in the near future) but when I try to bring, say for example the Role Name of the logged in user, it lifts all the role names and assigns them to the one logged in user. I think this is probably a simple question, but it is holding me up as I am learning as I go!
Thanks
|