How to get value from two diffrent tables

Go through below link for joins more then two tables 

 

http://www.dofactory.com/sql/join  

How to use INNER Join

----- Nested and Inner Join
Select F.Fac_Name as FName,F.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