Re: need help - Mailing list pgsql-sql

From Russell Keane
Subject Re: need help
Date
Msg-id 8D0E5D045E36124A8F1DDDB463D548557D1618F46E@mxsvr1.is.inps.co.uk
Whole thread Raw
In response to Re: need help  (Oliver d'Azevedo Cristina <oliveiros.cristina@gmail.com>)
List pgsql-sql
> Sorry, why do you need the joins?
>
> Best,
> Oliver

Strictly speaking, for the examples and results given, the joins are pointless when you can get all the info from the
'move'table (but then the problem is like the 'hello world' of SQL)
 
But then the other 2 tables are completely redundant in the examples (even for context they're not very useful), so I
madethe assumption that he would also want to retrieve some other information about the products or locations and the
joinswould then be required.
 

I think the question may be missing some details about what is actually wanted...



pgsql-sql by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: need help
Next
From: Misa Simic
Date:
Subject: Re: Summing & Grouping in a Hierarchical Structure