simple join is beating me

Поиск
Список
Период
Сортировка
От Gary Stainburn
Тема simple join is beating me
Дата
Msg-id 200907131134.14335.gary.stainburn@ringways.co.uk
обсуждение исходный текст
Ответы Re: simple join is beating me  (Oliveiros <oliveiros.cristina@gmail.com>)
Список pgsql-sql
hi folks

i have the following:

select o_ord_date as o_date, count(o_id) as orders   from orders where o_de_id in (5,6) and o_ord_date >
CURRENT_DATE-'1
 
month'::interval   group by o_ord_date
order by o_date desc

and

select o_act_del_date as o_date, count(o_id) as delivery    from orders    where o_de_id in (5,6) and
o_act_del_date> CURRENT_DATE-'1 month'::interval and         o_act_del_date <= CURRENT_DATE   group by o_act_del_date
 
order by o_date desc

These give me
  o_date   | orders
------------+--------2009-07-10 |      42009-07-09 |      52009-07-08 |     122009-07-07 |      52009-07-06 |
22009-07-03|      22009-07-02 |      72009-07-01 |     192009-06-30 |     202009-06-29 |     28
 

and 
  o_date   | delivery
------------+----------2009-07-13 |        52009-07-10 |        32009-07-09 |        42009-07-08 |        22009-07-07 |
      42009-07-06 |        72009-07-03 |        62009-07-02 |        52009-07-01 |        32009-06-30 |        3
 

How do i get
  o_date   | orders | delivery
------------+--------+----------2009-07-13 |        |        52009-07-10 |      4 |        32009-07-09 |      5 |
42009-07-08 |     12 |        22009-07-07 |      5 |        42009-07-06 |      2 |        72009-07-03 |      2 |
62009-07-02|      7 |        52009-07-01 |     19 |        32009-06-30 |     20 |        3
 
-- 
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000    


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Surajit Bhattacharjee"
Дата:
Сообщение: function returning a cursor and a scalar
Следующее
От: Oliveiros
Дата:
Сообщение: Re: simple join is beating me