Saturday, January 9, 2010

Get vtigerCRM Account List

The following query get vtigerCRM Account List

SELECT t1.account_no AS 'Account No'
, t1.accountname AS 'Account Name'
, t4.bill_city AS 'City'
, t1.website AS 'Website'
, t1.phone AS 'Phone'
, t3.user_name AS 'Assigned To'
FROM vtiger_account t1
INNER JOIN vtiger_crmentity t2 ON t1.accountid = t2.crmid AND t2.setype = 'Accounts'
INNER JOIN vtiger_users t3 ON t2.smownerid = t3.id
LEFT JOIN vtiger_accountbillads t4 ON t1.accountid = t4.accountaddressid

No comments:

Post a Comment