This query gets all vtigerCRM vendors
SELECT t1.vendor_no
, t1.vendorname
, t1.phone
, t1.email
, t1.category
FROM vtiger_vendor t1
INNER JOIN vtiger_crmentity t2 ON t1.vendorid = t2.crmid AND t2.setype = 'Vendors'
Sunday, January 10, 2010
Get all vtigerCRM vendors
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment