Re: date range query help

> Now user Ben has passed his mobile to user Josh and we issued Josh his
> mobile on 2008-10-15.
>
> 1. Is it possible for me to write a query that will have the fields
>
> call.call_id,
> call.datetime,
> mobile_custodian.user_id,
> call.mobile_no
> call.charge
>
> that will use call.datetime and lookup the date range from
> mobile_custodian.issue_date and mobile_custodian.return_date to
> identify the right user for each call?
>
> 2.  Do I need to change the issue_date & return_date fields to
> timestamp to perform the above?
>

No, a date will work fine.  Try this:


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