"Shanimal" <sh******@att.net> wrote in message
news:11*********************@i40g2000cwc.googlegro ups.com...
I don't think there is a relation between the two tables.
You said you want both the system name and the bios serial number. Which
bios serial number goes with which system name?
This is the concept of a join: to express the criteria for matching rows of
one table to rows of another table. How they match up is the relationship
between the two tables.
It's possible that you do not have the right information in these two tables
to express the relationship. This would naturally make it hard to envision
the join criteria.
For instance, as in noone's example, it is typical that there is a column
that appears in both tables. Where you find identical values in that column
in both tables, that's the definition of rows that match. But you don't
seem to have that column in common between the two tables, so you may have
no expressable relationship given the current state of the data.
The other possibility is that you need a third table to express the
relationship. This is useful if one bios can match multiple systems, and
also one system can match multiple bios's. This is called a "many-to-many"
relationship. You'd need to join this third table to both the bios table
and the system table in one query, in order to match up all the entries.
Regards,
Bill K.