> 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 made the assumption that he would also 
want to retrieve some other information about the products or locations and the 
joins would then be required.

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



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

Reply via email to