I have a supplier table and a Purchase Order table.
I want to a query that will list all the suppliers that
have purchase orders, but only once for each unique
supplier, although a supplier may have several purchase orders or none.

"Tom" <(E-Mail Removed)> wrote in message
news:bdidnZ2QHaX5U-(E-Mail Removed)...
>I have a supplier table and a Purchase Order table.
> I want to a query that will list all the suppliers that
> have purchase orders, but only once for each unique
> supplier, although a supplier may have several purchase orders or none.

Something like:

SELECT DISTINCT Suppliers.*
FROM Suppliers INNER JOIN PurchaseOrders ON Suppliers.SupplierID =
PurchaseOrders.SupplierID;
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com