Query empty records

[Luis]

I have a simple query to retrieve total order amount by customers, ie,

selet customers.customer_id, customers.customer_name,
sum(orders.order_amount) as total_orders from customers inner join, etc,
etc...

which work fine but only retrieves those customers for which there are
orders....

any way to retrieve the ones without orders as well, with a zero value on
the total_order field?

thanks, Luis

[Jeff Cochran]

On Thu, 18 Dec 2003 12:16:53 +0100, "Luis"
<sanchezaparicioREMOVE_THIS@hotmail.com> wrote:

>I have a simple query to retrieve total order amount by customers, ie,
>
>selet customers.customer_id, customers.customer_name,
>sum(orders.order_amount) as total_orders from customers inner join, etc,
>etc...
>
>which work fine but only retrieves those customers for which there are
>orders....
>
>any way to retrieve the ones without orders as well, with a zero value on
>the total_order field?

Have you tried an outer join?

Jeff