how to get data from multipla table????

[unika010690]

i have a project..i need to search the user info,,

the search by cbo has this items :
Finance Name
Address
Finance Type

when i click the search button the data from database should load into the data gridview in the middle when i select one data it must be display in the textboxes..
employee name is from General.Person table (Lastname,Firstname,middlename)
department is from HumanResources.Department table (DeptID=description)
Login name and password from General.UserMaster table
and how am i going to code the update password???we are using n-tier application,,
pllsss help,,

[debasisdas]

1. You can create a view based on the records of the JOIN between the relevant tables for the purpose of search.
2. While updating you need to update only one master table by pulling / selecting record from the above mentioned view.