Urgent...Subselect query

R

Richie

I am working with Access 2003. I have two tables, the first being
COMPANY and the second being VENDOR. Each row in COMPANY and VENDOR
are unique, however there is a one-to-many relationship. For every row
in the COMPANY table, there could be tens of rows in the VENDOR table.
What I need to return is all the rows in the COMPANY table with a
column appended to each row from the VENDOR table. The column from the
VENDOR table should be the first record that COMPANY.

In need of help,
richie
 
M

Mike Revis

Hi
In my world a Vendor *IS* a Company. What information is contained in the
vendor table that is not contained in the Company table? Perhaps if you
could tell us a little more about your table structure and clarify your
question.....

Regards

Mike
 
Top