DROP VIEW people;
CREATE VIEW people AS
  SELECT contact.firstname, contact.lastname, contact.username, contact.visible,
         phoneline.extension, department.name,
         contact.field1, contact.field2, contact.field3, contact.field4, contact.field5
    FROM contact, contact_department, department, phoneline
   WHERE contact.id = contact_department.contact AND department.id = contact_department.department AND contact.id = phoneline.lookupid
         AND phoneline.function = 'contact' AND contact.status = 'active' AND phoneline.status = 'active';

