How to write query to retrieve from two linked tables

ketan borsdiya10y ago

Accepted 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 Sawardekar10y ago

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 Rajab10y ago

users table [ UniID, user_type, Full_Name]UiID Pk

Module relation table table[ id,UniID, MId MName] UniID fk

I want to user name where a user type ="sth " and that user id inModule relation table

please help

Nilesh Sawardekar10y ago

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