> ## Documentation Index
> Fetch the complete documentation index at: https://docs.revenuebase.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Pre-Joined Tables

> Pre-joined RevenueBase tables combine Person, Organization, and Insight into a single view — query B2B contacts, firmographics, and signals without writing SQL joins.

<Note>
  The [Data Dictionary](/docs/data-features/data-dictionary) has the most up-to-date field definitions for all RevenueBase tables. Use it as your primary reference for column names and descriptions.
</Note>

Pre-Joined Tables are ready-made views that combine multiple base tables (e.g., Person/Contacts, Companies, Insight) 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 [Person + Organization](/docs/data-features/pre-joined-tables/person-organization) or [Person + Organization + Insight](/docs/data-features/pre-joined-tables/person-organization-insight) and filter or aggregate as needed.

### Available pre-joined views

| Table Name                           | View                                                                                                 | Description                                            |
| ------------------------------------ | ---------------------------------------------------------------------------------------------------- | ------------------------------------------------------ |
| `VELOCITY_BASE_UNLIMITED_LATEST`     | [Person + Organization](/docs/data-features/pre-joined-tables/person-organization)                   | Contacts joined to Organization (one row per contact). |
| `VELOCITY_ENHANCED_UNLIMITED_LATEST` | [Person + Organization + Insight](/docs/data-features/pre-joined-tables/person-organization-insight) | Contacts, Organization, and Insight in one view.       |

### When to use which

* **Person + Organization** — When you need contact and organization attributes together (e.g., contact email + organization name) without insight fields.
* **Person + Organization + Insight** — 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](/docs/data-feeds/joining-overview).