My data resides in the following 3 tables with these links:

Agents Buildings Tenants

name name name
agent_id <----> agent_id
bldg_id <------> bldg_id


Agents and Tenants don't have a common field. How can I SELECT all the tenants of a particular agent? Will I have to add the agent_id to the tenant table?

Thanks in advance!