office.name = $l

1. attach table to each field

{table=location, column=office, alias="a", pk="id"}.{leaf=name}

2. join

   on . = ?. join location a on a.id = user.office

3. select .

   select a.name

user

office.manager.name = $l

1. attach table to each field

{table=user, alias="user"}.{table=location, column=office, alias="a", pk="id"}.{table=user, column=manager, alias="b", pk="id"}.{leaf=name}

2. join

on . = <parent.alias>. join location a on a.id = user.office join user b on b.id = a.manager

4. select <parent.alias>.

   select a.name