Re: simple join is beating me

Howdy, Gary,<br /><br />I have not the database in this computer, so I cannot test the sql I'm sending you, but<br />if
youdo an outer join won't it result in what you need? Maybe I am not reaching what you want to do...<br /><br />SELECT
deliveryQuery.o_date, orders, delivery<br />FROM (/* ur first query here */) ordersQuery<br />NATURAL RIGHT JOIN (/* ur
secondquery goes here */) deliveryQuery<br />ORDER BY deliveryQuery.o_date DESC<br /><br />Tararabite,<br /><br
/>Oliveiros<br />@Allgarve<br /> <br /><br /><br /><div class="gmail_quote">2009/7/13 Gary Stainburn <span
dir="ltr"><<ahref="mailto:gary.stainburn@ringways.co.uk"
target="_blank">gary.stainburn@ringways.co.uk</a>></span><br/><blockquote class="gmail_quote" style="border-left:
1pxsolid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> hi folks<br /><br /> i have the
following:<br/><br /> select o_ord_date as o_date, count(o_id) as orders<br />    from orders where o_de_id in (5,6)
ando_ord_date > CURRENT_DATE-'1<br /> month'::interval<br />    group by o_ord_date<br /> order by o_date desc<br
/><br/> and<br /><br /> select o_act_del_date as o_date, count(o_id) as delivery<br />    from orders<br />    where
o_de_idin (5,6) and<br />          o_act_del_date > CURRENT_DATE-'1 month'::interval and<br />        
 o_act_del_date<= CURRENT_DATE<br />    group by o_act_del_date<br /> order by o_date desc<br /><br /> These give
me<br/><br />   o_date   | orders<br /> ------------+--------<br />  2009-07-10 |      4<br />  2009-07-09 |      5<br
/> 2009-07-08 |     12<br />  2009-07-07 |      5<br />  2009-07-06 |      2<br />  2009-07-03 |      2<br />
 2009-07-02|      7<br />  2009-07-01 |     19<br />  2009-06-30 |     20<br />  2009-06-29 |     28<br /><br /> and<br
/><br/>   o_date   | delivery<br /> ------------+----------<br />  2009-07-13 |        5<br />  2009-07-10 |      
 3<br/>  2009-07-09 |        4<br />  2009-07-08 |        2<br />  2009-07-07 |        4<br />  2009-07-06 |      
 7<br/>  2009-07-03 |        6<br />  2009-07-02 |        5<br />  2009-07-01 |        3<br />  2009-06-30 |      
 3<br/><br /> How do i get<br /><br />   o_date   | orders | delivery<br /> ------------+--------+----------<br />
 2009-07-13|        |        5<br />  2009-07-10 |      4 |        3<br />  2009-07-09 |      5 |        4<br />
 2009-07-08|     12 |        2<br />  2009-07-07 |      5 |        4<br />  2009-07-06 |      2 |        7<br />
 2009-07-03|      2 |        6<br />  2009-07-02 |      7 |        5<br />  2009-07-01 |     19 |        3<br />
 2009-06-30|     20 |        3<br /> --<br /> Gary Stainburn<br /><br /> This email does not contain private or
confidentialmaterial as it<br /> may be snooped on by interested government parties for unknown<br /> and undisclosed
purposes- Regulation of Investigatory Powers Act, 2000<br /><font color="#888888"><br /> --<br /> Sent via pgsql-sql
mailinglist (<a href="mailto:pgsql-sql@postgresql.org" target="_blank">pgsql-sql@postgresql.org</a>)<br /> To make
changesto your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-sql"
target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br/></font></blockquote></div><br />