I have a best practices question regarding table joins. I am looking at a query where the tables are joined similar to the example below: SELECTA.ColumnA, B.ColumnB FROM Customers C JOIN Addresses A ON A. (C.CustomerID = A.CustomerID) AND (A.DefaultAddress = 1) WHERE(A.EffectiveDate < GETDATE()) Seems the default address flag should go in the where clause. Does it really matter? Are there performance advantages one way or another? Thanks, Mike The revolution is just a t-shirt away.