Customer Account List



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 AS Account_Name,, 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 =
WHERE (Accounts.account_type = 'Customer')

Open Query