how Eight tables using joins in sql server 2008r2?

It is possible as long as you know which columns from which all tables are related and hence to be matched.

Here is an example query for 3 tables:

SELECT p.Name, v.Name
FROM Production.Product p
JOIN Purchasing.ProductVendor pv
ON p.ProductID = pv.ProductID
JOIN Purchasing.Vendor v
ON pv.BusinessEntityID = v.BusinessEntityID
WHERE ProductSubcategoryID = 15
ORDER BY v.Name;

[Please encourage participation by up-voting solutions or answers that work for you]