combining two tables

[ZOCOR]

Hi

how to combine two tables using sql

I have:

table 1 (id, name, address)

table 2 (id, fax, phone)

would like:

table (id, name, address, fax, phone)


Thanks
ZOCOR

 

[Tom Ellison]

Dear Zocor:

Are the two table related on "id"? Do they have the same number of
rows (a 1 to 1 relationship)? Are there rows in either table without
a corresponding row in the other?

You can JOIN two table in a query based on some common key that us
generally unique in one or both tables. The details will depend on
the characteristics of the relationship between the tables, which is
what I was asking above.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts