SQL statement

[sabrina]

I am trying to find a customer numbers, customer names and sales rep number for all customers that have open orders. using an alias O for the Open Orders table and C for Customers table. I need each cusotmer should appear only once. How would I write this in a SQL statement. My tables are Open Orders and Customers.

[alansidman]

In your open orders table, what field(s) determines that a customer has an open order. How is it determined? How is it determined that an order is closed?

[goodguy]

Select c.customerno, c.customername, c.salesrep from customers as c
inner join (select o.orderno, o.customerno from openorders as o where o.orderstatus = "open") as oo
on c.customerno = oo.orderno