4pm sql command back up

get all the agents or agency that belong to IPAV

  SELECT * from [findahome].[dbo].[Agent] agent
  left join [findahome].[dbo].[AgencyOffice] ao on ao.idOffice = agent.idOffice
  left join [findahome].[dbo].[Agency] agency on agency.idAgency = ao.idAgency
  where agency.idAffiliation = 3
  
  select * from  [findahome].[dbo].[Agency] where idAffiliation = 3