Re: need help

Поиск
Список
Период
Сортировка
От Russell Keane
Тема Re: need help
Дата
Msg-id 8D0E5D045E36124A8F1DDDB463D548557D1618F46E@mxsvr1.is.inps.co.uk
обсуждение исходный текст
Ответ на Re: need help  (Oliver d'Azevedo Cristina <oliveiros.cristina@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: need help
Следующее
От: Misa Simic
Дата:
Сообщение: Re: Summing & Grouping in a Hierarchical Structure