Urgent...Subselect query

  • Thread starter Thread starter Richie
  • Start date Start date
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
 
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
 
Back
Top