plz exaplain me how to fetch details of user?

Question

in Sql database have one table in that table they 4 coloumn with usernames and passwords and another table have one username and password details when the program excute time how we will when we will enter the on username and password in the textboxs the will show particular details of that user how it come plz exaplain me