ODBC > Extract Customers From Opportunity

Join TRANSACTIONS, CUSTOMERS AND OPPORTUNITIES table by using this join:

TRANSACTIONS.TRANSACTION_ID = OPPORTUNITIES.TRANSACTION_ID
TRANSACTIONS.ENTITY_ID = CUSTOMERS.CUSTOMER_ID
 

Example:

SELECT TRANSACTIONS.ENTITY_ID,CUSTOMERS.COMPANYNAME FROM TRANSACTIONS
INNER JOIN OPPORTUNITIES
ON TRANSACTIONS.TRANSACTION_ID = OPPORTUNITIES.TRANSACTION_ID
INNER JOIN CUSTOMERS
ON TRANSACTIONS.ENTITY_ID = CUSTOMERS.CUSTOMER_ID