References: 
 <CACotafd7p+MR6famJHOTLQrCMrYRPRSEP8YrNR6PGQ7jNbgBjA@mail.gmail.com>
	<CAAk_w-qkwCtrKP5FH4Xro0=xdKj=LAnBdG4ZaV1s7fd5_eRSRw@mail.gmail.com>
	<CACotaffP=gssaBJ6D9zkUb1H5bP5bMJXGwE5iWXJmwQ_AMVCLQ@mail.gmail.com>
In-Reply-To: 
 <CACotaffP=gssaBJ6D9zkUb1H5bP5bMJXGwE5iWXJmwQ_AMVCLQ@mail.gmail.com>
Mime-Version: 1.0 (iPhone Mail 8L1)
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8
Message-Id: <76AB0A60-BB3E-4674-881A-F0DF0ECE7F0B@gmail.com>
Cc: Carlos Chapi <carlos.chapi@2ndquadrant.com>,
	"pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
From: Oliver d'Azevedo Cristina <oliveiros.cristina@gmail.com>
Subject: Re: need help
Date: Thu, 21 Feb 2013 20:35:00 +0000
To: denero team <deneroteam@gmail.com>
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

SELECT move_id, product_id,destination_location as location_id
FROM product_move
Where datetime BETWEEN $first
AND $last

Have you tried something like this?

Best,
Oliver

Enviado via iPhone

Em 21/02/2013, =C3=A0s 08:20 PM, denero team <deneroteam@gmail.com> escreve=
u:

> Hi,
>=20
> Thanks for replying me. yes you are right at some level for my case.
> but its not what I want. I am explaining you a case by example.
>=20
> Consider following are data in each table
>=20
> Location :
> id , name, code
> 1, stock, stock
> 2, customer, customer
> 3, asset, asset
>=20
> Product :
> id, name, code, location
> 1, product1, p1, 1
> 2, product2, p2, 3
>=20
>=20
> Product_Move :
> id, product_id, source_location, destination_location, datetime
> 1, 1, Null, 1, 2012-10-15 10:00:00
> 2, 2, Null, 1, 2012-10-15 10:05:00
> 3, 2, 1, 3,  2012-12-01 09:00:00
>=20
> Please review all data , you can see, current location of product1
> (p1) is 1 (stock) and current location of product2 (p2) is 3 (asset).
>=20
> now i want to find location of all products for given period
>=20
> for example : 2012-11-01 to 2012-11-30, then i need result should be like=
 below
> move_id, product_id, location_id
> 1, 1, 1
> 2, 2, 1
>=20
> another example : 2012-11-01 to 2012-12-31
> move_id, product_id, location_id
> 1, 1, 1
> 2, 2, 1
> 3, 2, 3
>=20
> Now I really don't know how to do this.
>=20
> can you advise me more ?
>=20
>=20
> Thanks,
>=20
> Dhaval
>=20
>=20
> On Fri, Feb 22, 2013 at 1:26 AM, Carlos Chapi
> <carlos.chapi@2ndquadrant.com> wrote:
>> Hello,
>>=20
>> Maybe this query can help you
>>=20
>> SELECT p.name, l.name
>> FROM location l
>> INNER JOIN product_move m ON m.source_location =3D location.id
>> INNER JOIN product p ON m.product_id =3D p.id
>> WHERE p.id =3D $product_id
>> AND m.datetime < $given_date
>> ORDER BY datetime DESC LIMIT 1
>>=20
>> It will return the name of the product and the location for a given id a=
nd
>> date.
>>=20
>>=20
>> 2013/2/21 denero team <deneroteam@gmail.com>
>>>=20
>>> Hi All,
>>>=20
>>> I need some help for my problem.
>>> Problem :
>>> I have following tables
>>> 1. Location :
>>>    id, name, code
>>> 2. Product
>>>    id, name, code, location ( ref to location table)
>>> 2. Product_Move
>>>    id, product_id ( ref to product table), source_location (ref to
>>> location table) , destination_location ( ref to location table) ,
>>> datetime ( date when move is created)
>>>=20
>>> now i want to know for given period of dates, where is the product
>>> actually.
>>>=20
>>> can anyone help me ??
>>>=20
>>> Thanks,
>>>=20
>>> Dhaval
>>>=20
>>>=20
>>> --
>>> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-sql
>>=20
>>=20
>=20
>=20
> --=20
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql


--=20
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql