Skip to main content
Pre-Joined Tables are ready-made views that combine multiple base tables (e.g., People/Contacts, Companies, Insights) so you can query them without writing joins yourself. Use them when you need a single table that already links people, companies, and optional insight data.

​
Benefits of pre-joined tables

  • Fewer joins — Query one table instead of joining tables manually.
  • Consistent keys — Join keys and relationships are defined and documented for each pre-joined view.
  • Easier analytics — Start with People + Organizations or People + Organizations + Insights and filter or aggregate as needed.

​
Available pre-joined views

ViewDescription
People + OrganizationsContacts joined to Organizations (one row per contact).
People + Organizations + InsightsContacts, Organizations, and Insights in one view.

​
When to use which

  • People + Organizations — When you need contact and organization attributes together (e.g., contact email + organization name) without insight fields.
  • People + Organizations + Insights — When you also need insight or score fields on the same row.
For custom joins or other combinations, use the base tables and Joining tables.