Re: date range query help

novice wrote:
> 2008/11/20 Adam Rich <adam(dot)r(at)sbcglobal(dot)net>:
>>
>> select call.call_id,
>> call.datetime,
>> mobile_custodian.user_id,
>> call.mobile_no
>> call.charge
>> from call, mobile_custodian
>> where call.mobile_no = mobile_custodian.mobile_no
>> and call.datetime between mobile_custodian.issue_date
>> and mobile_custodian.return_date
>
> sorry I get nothing :(
>

How about:

SELECT call.call_id,
call.datetime,
mobile_custodian.user_id,
call.mobile_no,
call.charge
FROM call
LEFT JOIN mobile_custodian
ON call.mobile_no = mobile_custodian.mobile_no
AND call.datetime
BETWEEN
mobile_custodian.issue_date
AND
mobile_custodian.return_date;