How to write query to retrieve from two linked tables

Question

I need to retrieve user Id from module Relation table based on the user type which is in user table and they have relationship

Please how to write that query in sql data source tag

<asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT distinct [Full_Name], [UniID] FROM [Users] WHERE [UniID]= (SELECT [UniID]from [ModuleRelation]) AND [user_type]='Staff'"></asp:SqlDataSource>

Please help

thank you

ketan borsdiya · Answer

Hi Joma Try below query Select Full_Name from U INNER JOIN R ON U.UniID=R.UniID WHERE U.user_type='sth '

Nilesh Sawardekar · Answer

Your username which you want user type which you want to compare and user id still not found in any of table but lets consider it is uniID all things are in same table <Users> then why you want to take inModule Relation table in picture.

Joma Rajab · Answer

users table [ UniID user_type Full_Name ] UiID Pk Module relation table table [ idUniID MId MName ] UniID fk I want to user name where a user type =sth  and that user id inModule relation table please help

Nilesh Sawardekar · Answer

Give us both tables fields name and also some info like which columns your looking in final output.