Creating a Unified Table for Call Scripts and Email Templates

if i have two or three connected tables (find companies, find people from those companies, etc.) and I want to create one final table that generates call scripts/email templates and sends to http api endpoints, how do I create another table that will allow me to call columns from the other connected tables?