Tom,
Try this:
SELECT tenants.* ;
FROM tenants, buildings, agents ;
WHERE tenants.bldg_id=buildings.bldg_id AND ;
buildings.agent_id=agents.agent_id AND ;
agents.Name='Joe Agent'
>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?