| From: | Russell Keane <Russell(dot)Keane(at)inps(dot)co(dot)uk> |
|---|---|
| To: | Oliver d'Azevedo Cristina <oliveiros(dot)cristina(at)gmail(dot)com> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: need help |
| Date: | 2013-02-22 08:31:26 |
| Message-ID: | 8D0E5D045E36124A8F1DDDB463D548557D1618F46E@mxsvr1.is.inps.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 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...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Misa Simic | 2013-02-22 09:00:34 | Re: Summing & Grouping in a Hierarchical Structure |
| Previous Message | Jaime Casanova | 2013-02-22 03:55:08 | Re: need help |