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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Sorting and grouping using multiple tables 0
Contact database - linking tables 1
MTA Query Help 1
combo box problem 2
Subform causing duplicate records? 7
Switching from FileMaker Pro 9 to Access '07 4
Basic table structure/relationships for a vendor database 6
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top