Re: [GENERAL] date range query help

Wed, 19 Nov 2008 19:34:42 -0800 

novice wrote:

2008/11/20 Adam Rich <[EMAIL PROTECTED]>:


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;

--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general






















					Reply via email to