Sample SQL Query to Get the Contact Details such as "Job Title" within the Customer Record in ODBC

To get the details of the contacts based on the customer record it is attached via ODBC, users can join the Contacts and Customers table using "COMPANY_ID" and "CUSTOMER_ID" respectively.

Below is a sample query to show the "Job Title" of the contacts:

SELECT Contacts.TITLE
FROM Customers
INNER JOIN Contacts
ON Customers.CUSTOMER_ID = Contacts.COMPANY_ID