From: | novice <user(dot)postgresql(at)gmail(dot)com> |
---|---|
To: | brian <brian(at)zijn-digital(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: date range query help |
Date: | 2008-11-20 03:43:00 |
Message-ID: | ddcb1c340811191943t30bffd91i3996dec58b0f705f@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice pgsql-sql |
2008/11/20 brian <brian(at)zijn-digital(dot)com>:
> 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;
>
this gave me nothing on the user_id field :(
call_id | datetime | user_id | mobile_no | charge
---------+---------------------+---------+-------------+--------
1 | 2007-10-12 10:00:00 | | 09455225998 | 4.5
2 | 2007-10-16 13:27:00 | | 09455225998 | 5.2
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2008-11-20 03:58:40 | Re: [GENERAL] db_user_namespace, md5 and changing passwords |
Previous Message | brian | 2008-11-20 03:28:03 | Re: date range query help |
From | Date | Subject | |
---|---|---|---|
Next Message | Rodrigo E. De León Plicet | 2008-11-20 04:17:18 | Re: [SQL] date range query help |
Previous Message | brian | 2008-11-20 03:28:03 | Re: date range query help |
From | Date | Subject | |
---|---|---|---|
Next Message | Rodrigo E. De León Plicet | 2008-11-20 04:17:18 | Re: [SQL] date range query help |
Previous Message | brian | 2008-11-20 03:28:03 | Re: date range query help |