Could you give us a little more information? Table names, column names? Do you mean joining 3 tables or using 3 columns to join 2 tables?

Here's an example of a 3 table join:

[font="Courier New"]/* tables

Orders(OrderID Primary Key, CustomerID, OrderDate)

OrderDetails(OrderDetailID Primary Key, OrderID, ProductId, OrderQty)

Products(ProductID Primary Key, ProductName, ProductDescription)

*/

SELECT

   O.OrderDate,

   D.OrderQty,

   P.ProductName

FROM

   dbo.Orders O INNER JOIN

   dbo.OrderDetails D ON

       O.OrderID = D.OrderID INNER JOIN

   dbo.Products P ON

       D.ProductID = P.ProductID[/font]