Customer Account List

SugarCRM

 

SugarCRM is a cloud CRM from the SugarCRM software company, that includes sales force automation, marketing campaigns, customer support, collaboration, reporting, etc. features.

Customer Account List

Query Text

SELECT Accounts.name AS Account_Name, Accounts.website, Accounts.phone_office AS "Phone Office", Accounts.description, Accounts.account_type AS Type, accounts_assigned_user.full_name AS User, accounts_assigned_user.last_login
  FROM Accounts
LEFT OUTER JOIN Users AS accounts_assigned_user ON Accounts.assigned_user_id = accounts_assigned_user.id
WHERE (Accounts.account_type = 'Customer')
  

Open Query