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]