>>>I have two tables - we'll call them Customer and Bill. A customer can have zero or many bills, and it is linked by the CustomerID. What I want to do is pull a customer by CustomerID and also pull their last bill only if it is within 30 days old. If there isn't a bill that fits that criteria, I want null value.
>>>
>>>Can I do this with a JOIN? Anybody have any advice on how to do the filtering in the JOIN statement?
>>
>>Try
>>

>>SELECT *
>>	FROM Customer c
>>		LEFT JOIN (SELECT TOP 1 FROM Bill b
>> 			WHERE CustomerID = @CustomerID AND BillDate > ...
>>                              ORDER BY BillDate DESC) bd on bd.CustomerID = c.CustomerID
>>	WHERE c.CustomerID = @CustomerID
>>

>
>You're the man, Sergey.
>
>(I haven't tried it yet, but if you say it will work I'm sure it will ;-))

I didn't say it'll work :)
You have to try it first.