Input:

  let office = "JCMB-3311" in
  [ (person.surname, person.firstname) 
   | person <- (table1),
     occupier <- (table2),
     occupier.office == office,
     person.id == occupier.personid ]


Output:
   
  (SELECT table_21.surname AS surname, 
          table_21.firstname AS firstname FROM person AS table_21, 
          occupies AS table_22
   WHERE ((table_22.office = 'JCMB-3311') 
      AND (table_21.id = table_22.personid)) 
   ORDER BY table_21.surname ASC, table_22.personid ASC)