如何在文本框中显示数据库中的值？

Question

您好，我有像这样的数据库

Users Table

     user_id |   username  |  branch_id(foreignkey)|  Approved_id(foreignkey)
  -------------------------------------------------------------------------------
    1          jprescott         2                          1
    2          lpausch           1                          3

Branch Table

---

Branch_id    BranchName        
1                abc                    
2               asjdv                 
3               ydgfs             

Approvetable

---

     ApproveId  ApprovedBy
          1         Anil
           2         ghouse
           3         raghu

现在我有 3 个文本框，当用户 1 登录时，我如何在文本框中输入这些字段，

          txtusername.text=username from table 1;
          txtapprovedname=approved by from table 2;
          txtbranchname=branchname from table 3;

它应该检查分支 id 并转到分支表并显示分支名称，然后检查批准并转到批准表并在文本框中显示批准名称......

现在如何为此编写一条选择语句任何人都可以帮助我..............

Answer 1

select UsersTable.username, ApproveTable.ApprovedBy, Branchtable.BranchName
from UsersTable, Branchtable, Approvetable
where UsersTable.branch_id = BranchTable.branch_id
AND UsersTable.approved_id = ApproveTable.ApproveId
AND UsersTable.User_id = %CurrentUserID%