one should primary key, other one not needed.
link on comparable fields
same data types
on primary key, no duplicates
data should be consistent when you make the link


SELECT LastName, FirstName, Max(Price) AS thePrice
FROM Author, Book where AuthorID = AuthorCode
GROUP BY LastName, FirstName;

parameters, calculated fields

Like "G*"