Thursday, August 27, 2015

How to join Projects and Customers tables

SELECT proj.segment1 project#, proj.NAME proj_name,
       hc.account_number customer_account_number#
  FROM pa_projects_all proj, pa_project_customers pc, hz_cust_accounts hc
 WHERE 1 = 1
   AND proj.project_id = pc.project_id
   AND pc.customer_id = hc.cust_account_id

No comments: