Oh, I actually thought that it was the behavior you wanted, Gary.
On the example you supplied you have an order on June , the 29th and it
doesn't
appear on the result you showed.
You wanted this row do appear as an NULL delivery?
Just try replacing the RIGHT JOIN
by FULL JOIN.
This will cause al
> From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-
> ow...@postgresql.org] On Behalf Of Gary Stainburn
> Sent: Monday, July 13, 2009 9:12 AM
>
> If a date exists where we have orders but no deliveries the row does
not
> appear.
> I have tried doing a union to link the two selects together, b
Hi Oliveiros,
Thank you for this. However, this does not give me what I want.
If a date exists where we have orders but no deliveries the row does not
appear.
I have tried doing a union to link the two selects together, but i still
cannot get anything to work.
Gary
On Monday 13 July 2009 12:
Howdy, Gary,
I have not the database in this computer, so I cannot test the sql I'm
sending you, but
if you do an outer join won't it result in what you need? Maybe I am not
reaching what you want to do...
SELECT deliveryQuery.o_date , orders, delivery
FROM (/* ur first query here */) ordersQuery
