Thanks all for your concern and help. I have tried David suggestion and it works. As what you all said, there are so many important feature in PostgreSQL. I really have to spend time to study it. Last time i use Windev to develop front end application, and HyperfileSQL as the database server. This makes me headache :D Postgre really fast, has excellent feature, clear documentation, has great community and really so many plus point. Thanks you all. On Nov 18, 2013, at 4:47 PM, Raymond O'Donnell wrote: > On 18/11/2013 02:16, Hengky Liwandouw wrote: >> Dear Friends, >> >> Please help for the select command, as i had tried many times and >> always can not display the result as what i want. >> >> I am looking for the solution on google but still can not found the >> right answer to solve the problem. >> >> I have 3 tables : >> >> Table A ProductID ProductName SupplierID >> >> Table B ProductID InitialStock >> >> Table C ProductID Date In Out >> >> 1. I want to select all productID from Table A where >> supplierID='XXX'. >> >> 2. Based on list from Step.1 : sum the initialstock from Table B >> >> 3. Based on list from Step 1 : Sum (in-out) from Table C where date >> <'BEGINNING DATE' >> >> 4. Based on list from Step 1 : Sum (in) and sum(out) from Table C >> where date between 'BEGINNING DATE' and 'ENDING DATE' >> >> So the result will look like this : >> >> ProductID ProductName SumofIntialStock sum(in-Out)<beginningdate >> SumofIN SumofOut xxxx xxxxxxxxxxxxx 99 >> 99 99 99 xxxx >> xxxxxxxxxxxxx 99 99 >> 99 99 xxxx xxxxxxxxxxxxx 99 >> 99 99 99 xxxx >> xxxxxxxxxxxxx 99 99 >> 99 99 > > You could try using common table expressions, which let you build up to > your final result in steps. Some reading: > > http://www.postgresql.org/docs/9.3/static/queries-with.html > > http://www.chesnok.com/daily/2013/11/12/how-i-write-queries-using-psql-ctes/ > > > Ray. > > > -- > Raymond O'Donnell :: Galway :: Ireland > rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
