Report Name: List of all Active Vendors

Purpose: Provide list of all active Vendors in Koha along with contact details and Koha ID.
Status: Complete tested on Koha 16.11.07



SELECT r.id 'Koha ID', r.name'Firm Name',i.name 'Contact Person',i.phone 'Phone/Mobile', i.email 'Email',r.postal 'Postal Address',r.fax 'Fax'
 
FROM aqbooksellers  r
LEFT JOIN aqcontacts i ON i.id=r.id
 
WHERE r.active LIKE '1'