novice wrote:
2008/11/20 Rodrigo E. De León Plicet <[EMAIL PROTECTED]>:
On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> wrote:
sorry I get nothing :(
Of course not. None of the dates you gave in the example overlap.
But it should still have the 1st entry with the name Ben? Am
2008/11/20 Rodrigo E. De León Plicet <[EMAIL PROTECTED]>:
> On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> wrote:
>> sorry I get nothing :(
>
> Of course not. None of the dates you gave in the example overlap.
>
But it should still have the 1st entry with the name Ben? Am I
missing
On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> wrote:
> sorry I get nothing :(
Of course not. None of the dates you gave in the example overlap.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pg
2008/11/20 brian <[EMAIL PROTECTED]>:
> 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.mobi
2008/11/20 Adam Rich <[EMAIL PROTECTED]>:
>> 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
