query to find vendor who's ordered the most stock

H

Helen Dangerfield

I have a table with vendors listed and a table for stock items ordered I need
to run a query to find the vendor who has ordered the most items
 
C

Chaim

There has to be some field that links these two entities. For example, a
third table that contains the vendor ID, a stock item ID, and maybe other
information about its purchase (quantity, date of sale, etc).

No linking information- which you have to provide somewhere, somehow- in
your database, no way to do the query.
 
Top