Hi Cableguy,
Yes, you are making sense - the hardest part of learning anything new is learning the terminology, but you expressed yourself well.
You received excellent advice from RandomCoder. I just thought I would give you one example. I have a Major League Baseball Database that contains three tables: Master, Batting, and Pitching. The Master table contains static information about each player (name, date of birth, etc) along with a unique player ID. The Batting and Pitching tables contain season by season statistics, each entry contains the player ID for that record. Here is my query for pulling Babe Ruth's batting statistics:
SELECT Master.Rowid as _id, [Master].[nameLast], [Master].[nameFirst] FROM 'Master' JOIN 'Batting' on [Master].[playerID] = [Batting].[playerID] where Master.nameFirst LIKE "Babe" and Master.nameLast LIKE "Ruth"
Good luck, it's always fun learning new things!