... a join ( relation ) between two tables SELECT Customer.[First Name], Customer.[Last Name], Customer.Address1, Customer.City, Customer.State, Payments.[Payment Method], Payments.[Payment Amount], Payments.[Date Collected], Payments.[Invoice Number] FROM Customer LEFT JOIN Payments ON Customer.[Customer ...