How to get value from two diffrent tables

Question

Hello i am a new learner. I want to know How to get value from two different tables and show the value in the textbox. It will be very beneficial if you explain it easily.

Puneet Kankar · Answer

Go through below link for joins more then two tables http://www.dofactory.com/sql/join

Puneet Kankar · Answer

try join from this refer link https://www.w3schools.com/sql/sql_join.asp then go through this link for display record http://www.c-sharpcorner.com/blogs/retrieving-data-from-database-into-textbox1

Sandy Bhardwaj · Answer

How to use INNER Join ----- Nested and Inner Join Select F.Fac_Name as FNameF.Address as Faddress(Select B.Book_Name from Book B Where B.Book_Id = F.Fac_Id) as Book_Title S.Stu_Name as SName  S.Address as Saddress FROM Faculty F inner join Student S on F.Fac_Id=S.Stu_Id where F.Fac_Id=101 --======================= OUTPUT -- FName Faddress Book_Title SName Saddress -- Zaheer Quereshi Ajmer C# Programming Sandy Bhardwaj Jaipur

Methoun Ahmed · Answer

How to use inner join in c. Please explai and demo code