novice wrote:
> 2008/11/20 Adam Rich <adam.r@sbcglobal.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;