This seems like foundational stuff, but after trying to figure it out on my own all morning, I will just bask in my newbie-ness and ask for help.
I have a Schools table and a Staff table. The Schools table has all the addresses for multiple schools (School_Name, School_Address). The Staff table has all the staff that work at the different schools (Staff_Name, Position, School_Name (ref)). The tables are related with a ref to School_Name.
I would like to pull the data from the two tables together and be able to export a CSV inclusive of: Staff_Name, School_Name, School_Address. Any assistance would be most appreciated.