Basic Query question

[Tom]

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.

 

[Arvin Meyer [MVP]]

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;