References: 
 <CACotafd7p+MR6famJHOTLQrCMrYRPRSEP8YrNR6PGQ7jNbgBjA@mail.gmail.com>
	<CAAk_w-qkwCtrKP5FH4Xro0=xdKj=LAnBdG4ZaV1s7fd5_eRSRw@mail.gmail.com>
	<CACotaffP=gssaBJ6D9zkUb1H5bP5bMJXGwE5iWXJmwQ_AMVCLQ@mail.gmail.com>
	<76AB0A60-BB3E-4674-881A-F0DF0ECE7F0B@gmail.com>
	<8D0E5D045E36124A8F1DDDB463D548557D1618F45F@mxsvr1.is.inps.co.uk>
	<8D0E5D045E36124A8F1DDDB463D548557D1618F461@mxsvr1.is.inps.co.uk>
In-Reply-To: <8D0E5D045E36124A8F1DDDB463D548557D1618F461@mxsvr1.is.inps.co.uk>
Mime-Version: 1.0 (iPhone Mail 8L1)
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8
Message-Id: <DBE978E6-5887-4B69-943F-2FD59F018FA0@gmail.com>
Cc: Russell Keane <Russell.Keane@inps.co.uk>,
	"deneroteam@gmail.com" <deneroteam@gmail.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 22:26:11 +0000
To: Russell Keane <Russell.Keane@inps.co.uk>
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Sorry, why do you need the joins?

Best,
Oliver

Enviado via iPhone

Em 21/02/2013, =C3=A0s 09:28 PM, Russell Keane <Russell.Keane@inps.co.uk> e=
screveu:

>>> Now I really don't know how to do this.
>>>=20
>>> can you advise me more ?
>>>=20
>>>=20
>>> Thanks,
>>>=20
>>> Dhaval
>>=20
>>=20
>> I think these are the sqls you are looking for:
>>=20
>> SELECT pm.id as move_id, p.id as product_id, l.id as location_id
>> FROM product_move pm inner join product p on pm.product_id =3D p.id inne=
r join location l on pm.destination_location =3D l.id
>> and datetime BETWEEN '2010-1-01' AND '2012-12-31'
>=20
>=20
> Sorry, that should have been:
>=20
> For your 2 examples:
>=20
> SELECT pm.id as move_id, p.id as product_id, l.id as location_id
> FROM product_move pm inner join product p on pm.product_id =3D p.id inner=
 join location l on pm.destination_location =3D l.id
> and datetime < '2012-11-30'
>=20
> SELECT pm.id as move_id, p.id as product_id, l.id as location_id
> FROM product_move pm inner join product p on pm.product_id =3D p.id inner=
 join location l on pm.destination_location =3D l.id
> and datetime < '2012-12-31'
>=20
> I'm not what the use of the 'from' date is in your examples.
> Do you need to know the final destination of the product in that time per=
iod?
> Or every destination location of the product in that time period?
>=20
> Regards,
>=20
> Russell Keane
> INPS
>=20
> Follow us on twitter | visit www.inps.co.uk
>=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
> --=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