join query

[christyjs]

hai, i have a three tables one is tblstudent(uniq ueid=studentid) , tbllanguage(uni queid=languagei d,),tblstudlang (languageid and studentid)

now i want studentname from tblstudent and languagename from tblstudlang


how to write a join query of this?

help me..

[madankarmukta]

Join usually made on Primary key of the table. What the primary key of the table?

[christyjs]

Student id is the primary key from tblstudent and language id is the primary key from tblstudentlang table

[nico5038]

place tblstudent and tblstudentlang in the query editor (you can start a new view to get this editor) and drag and drop studentid from one table in the other. That's all.

Nic;o)