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 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