collating records from different SQL Server tables

[BobLewiston]

I'm starting to learn SQL Server. As part of that effort, I'm experimenting with accessing AdventureWorks sample databases.

In database AdventureWorks, I've been accessing table Person.Contact. Although in that table there are columns for a phone number and an email address, there are no columns for a postal address. I see columns for a postal address in table Person.Address, but in that table there is no column for a numerical value ContactID, or for a string value for the contact's name, as there is in table Person.Contact.

It seems to me, especially because each of these two tables' names start with "Person.", that these tables are somehow linked. However, I don't see any columns in either table which seem to allude to any other tables. For what it's worth though, each of the two tables has a column called "rowguid", the purpose of which I don't understand.

I'd like my app to display in a WinForm all the information available for each contact, but I don't know how to locate the Person.Address record corresponding to a given Person.Contact record. Can anybody tell me how to do this?

 

[office politics]

GUID short for globally unique identifier.

onec you find a record you wish to dispaly in one table, you should be abel to query other tables with "where rowguid = '<value>'" to find information on the same person

 

[kmote]

I'll need to see the structure of the tables including the indexes. If this is an example database, it may be trying to demonstrate the use of linking tables even though this would not be done in production.