---
title: What are REST endpoints that JOIN table data?
description: The DreamFactory API management platform's database-backed auto-generated APIs include REST endpoints that join table data.
image: https://blog.dreamfactory.com/hubfs/Imported_Blog_Media/What-are-REST-endpoints-that-JOIN-table-data.png
---

[![DreamFactory logo](https://cdn.prod.website-files.com/64ed8da8a866be7a702fbae0/68d51994d3678214b54acb60_dreamfactory-navbar-logo.svg)](https://www.dreamfactory.com/)

 Products & Services

[AI Data Gateway](https://www.dreamfactory.com/ai-data-gateway/overview)

[Overview Why DreamFactory exists](https://www.dreamfactory.com/ai-data-gateway/overview) [Data Gov, Comp, Security Policy enforcement at the API layer](https://www.dreamfactory.com/ai-data-gateway/ai-data-governance) [Standard API Layer One contract for every backend](https://www.dreamfactory.com/ai-data-gateway/standard-api-layer) [API Gateway Functionality Routing, auth, rate limits, observability](https://www.dreamfactory.com/ai-data-gateway/api-gateway-functionality) [Deployment & Integration Self-hosted, cloud, hybrid](https://www.dreamfactory.com/ai-data-gateway/on-premise-deployment-and-integration) [Developer Productivity Auto-generated, never hand-coded](https://www.dreamfactory.com/ai-data-gateway/ai-development-accelerated) [AI App Architectures Patterns for RAG, agents, MCP](https://www.dreamfactory.com/ai-data-gateway/enterprise-ai-architectures)

AI Data Models

[AIOpenAI](https://www.dreamfactory.com/use-cases/openai) [GGoogle Gemini](https://www.dreamfactory.com/use-cases/google-gemini) [CAnthropic Claude](https://www.dreamfactory.com/use-cases/anthropic-claude-landing) [LMeta Llama](https://www.dreamfactory.com/use-cases/meta-llama) [MMistral AI](https://www.dreamfactory.com/use-cases/mistral) [CoCohere](https://www.dreamfactory.com/use-cases/cohere)

Services and support

[Quickstart Service Packages Expert-led Quickstarts to production](https://www.dreamfactory.com/services-and-support/quickstart-services-packages)

API Management

[Generate & Manage REST APIs From any database, in seconds](https://www.dreamfactory.com/api-management/generate-rest-apis) [Features Security, scripting, self-hosted & more](https://www.dreamfactory.com/api-management/features) [API Generation The complete guide to auto-generated APIs](https://blog.dreamfactory.com/a-complete-guide-to-api-generation) [API Management Concepts, tools, and best practises](https://blog.dreamfactory.com/what-is-api-management-a-brief-overview-of-api-management-concepts-and-tools?_gl=1*jl0njh*_gcl_au*MjQzMjgwMTc3LjE3ODIzMjI3MzY)

 Use Cases

AI Use Cases

[AI Data Access Secure, governed reads for your LLMs](https://www.dreamfactory.com/use-cases/ai-data-access) [MCP Server Drop-in Model Context Protocol](https://www.dreamfactory.com/use-cases/mcp-server) [Legacy Modernization Wrap mainframes with REST](https://www.dreamfactory.com/use-cases/legacy-modernization) [Data Governance Audit every call, enforce every policy](https://www.dreamfactory.com/use-cases/data-governance)

[Customer Case Studies](https://www.dreamfactory.com/case-studies)

[Energy Modernization](https://www.dreamfactory.com/case-studies/energy-snowflake-modernization) [Government Modernization](https://www.dreamfactory.com/case-studies/government-mainframe-oracle-modernization) [Government Business Intelligence](https://www.dreamfactory.com/case-studies/government-sql-server-bi-analyst-queries) [Manufacturing Modernization](https://www.dreamfactory.com/case-studies/steel-manufacturing-sap-erp-modernization) [Financial Services Investor Portal](https://www.dreamfactory.com/case-studies/financial-services-sql-server-investor-portal) [Non-Profit Partner Data Sharing](https://www.dreamfactory.com/case-studies/non-profit-sql-server-partner-data-sharing) [Professional Services Exec Dashboards](https://www.dreamfactory.com/case-studies/professional-services-erp-dashboards) [Education HR and External Data Sharing](https://www.dreamfactory.com/case-studies/education-student-hr-sql-server-mysql-external-data-sharing)

 Industries

Industries

#### [Healthcare HIPAA-grade APIs across EHR, claims, and labs.](https://www.dreamfactory.com/use-cases/healthcare)

#### [Financial Services Portfolios, partners, and portals on one layer.](https://www.dreamfactory.com/use-cases/financial-services)

#### [Government Modernize mainframes without re-platforming.](https://www.dreamfactory.com/use-cases/government)

#### [Manufacturing SAP, MES, and shop-floor data, governed.](https://www.dreamfactory.com/use-cases/manufacturing)

#### [Spotlight How enterprises run on DreamFactory From healthcare to energy to finance — governance baked into every endpoint. Browse case studies →](https://www.dreamfactory.com/case-studies)

 Connectors

SQL Database

[SQL SQL Server](https://www.dreamfactory.com/connectors/sql-server) [OR Oracle](https://www.dreamfactory.com/connectors/oracle) [PG PostgreSQL](https://www.dreamfactory.com/connectors/postgresql) [My MySQL](https://www.dreamfactory.com/connectors/mysql)

NoSQL & Docs

[Dy DynamoDB](https://www.dreamfactory.com/connectors/dynamodb) [Do DocumentDB](https://www.dreamfactory.com/connectors/azure-documentdb) [Mo MongoDB](https://www.dreamfactory.com/connectors/mongodb) [Cb CouchDB](https://www.dreamfactory.com/connectors/couch-db)

Cloud Warehouses

[S3 S3](https://www.dreamfactory.com/connectors/amazon-s3) [Ab Azureblob](https://www.dreamfactory.com/connectors/azure-blob) [FS FTP/SFTP](https://www.dreamfactory.com/connectors/ftp-sftp) [LS Local Storage](https://www.dreamfactory.com/connectors/local-storage)

C & SaaS

[Sf Salesforce](https://www.dreamfactory.com/connectors/salesforce) [API REST / SOAP](https://www.dreamfactory.com/connectors/soap-to-rest)

[See all 30+ connectors](https://www.dreamfactory.com/connectors)

[Blog](https://blog.dreamfactory.com/)

[FREE 30 Minute Demo](https://www.dreamfactory.com/demo)

[![DreamFactory logo](https://cdn.prod.website-files.com/64ed8da8a866be7a702fbae0/68d51994d3678214b54acb60_dreamfactory-navbar-logo.svg)](https://www.dreamfactory.com/)

![hamburger](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/megamenu/menu-hamburger.svg) ![close](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/megamenu/close-menu.svg)

 Back to main menu

 Products & Services

 Use Cases

 Industries

 Connectors

[Blog](https://blog.dreamfactory.com/)

[FREE 30 Minute Demo](https://www.dreamfactory.com/demo)

[AI Data Gateway](https://www.dreamfactory.com/ai-data-gateway/overview)

[Overview Why DreamFactory exists](https://www.dreamfactory.com/ai-data-gateway/overview) [Data Gov, Comp, Security Policy enforcement at the API layer](https://www.dreamfactory.com/ai-data-gateway/ai-data-governance) [Standard API Layer One contract for every backend](https://www.dreamfactory.com/ai-data-gateway/standard-api-layer) [API Gateway Functionality Routing, auth, rate limits, observability](https://www.dreamfactory.com/ai-data-gateway/api-gateway-functionality) [Deployment & Integration Self-hosted, cloud, hybrid](https://www.dreamfactory.com/ai-data-gateway/on-premise-deployment-and-integration) [Developer Productivity Auto-generated, never hand-coded](https://www.dreamfactory.com/ai-data-gateway/ai-development-accelerated) [AI App Architectures Patterns for RAG, agents, MCP](https://www.dreamfactory.com/ai-data-gateway/enterprise-ai-architectures)

AI Data Models

[AIOpenAI](https://www.dreamfactory.com/use-cases/openai) [GGoogle Gemini](https://www.dreamfactory.com/use-cases/google-gemini) [CAnthropic Claude](https://www.dreamfactory.com/use-cases/anthropic-claude-landing) [LMeta Llama](https://www.dreamfactory.com/use-cases/meta-llama) [MMistral AI](https://www.dreamfactory.com/use-cases/mistral) [CoCohere](https://www.dreamfactory.com/use-cases/cohere)

Services and support

[Quickstart Service Packages Expert-led Quickstarts to production](https://www.dreamfactory.com/services-and-support/quickstart-services-packages)

AI Data Models

[Generate & Manage REST APIs From any database, in seconds](https://www.dreamfactory.com/api-management/generate-rest-apis) [Features Security, scripting, self-hosted & more](https://www.dreamfactory.com/api-management/features) [API Generation The complete guide to auto-generated APIs](https://blog.dreamfactory.com/a-complete-guide-to-api-generation) [API Management Concepts, tools, and best practises](https://blog.dreamfactory.com/what-is-api-management-a-brief-overview-of-api-management-concepts-and-tools?_gl=1*jl0njh*_gcl_au*MjQzMjgwMTc3LjE3ODIzMjI3MzY)

AI Use Cases

[AI Data Access Secure, governed reads for your LLMs](https://www.dreamfactory.com/use-cases/ai-data-access) [MCP Server Drop-in Model Context Protocol](https://www.dreamfactory.com/use-cases/mcp-server) [Legacy Modernization Wrap mainframes with REST](https://www.dreamfactory.com/use-cases/legacy-modernization) [Data Governance Audit every call, enforce every policy](https://www.dreamfactory.com/use-cases/data-governance)

[Customer Case Studies](https://www.dreamfactory.com/case-studies)

[Energy Modernization](https://www.dreamfactory.com/case-studies/energy-snowflake-modernization) [Government Modernization](https://www.dreamfactory.com/case-studies/government-mainframe-oracle-modernization) [Government Business Intelligence](https://www.dreamfactory.com/case-studies/government-sql-server-bi-analyst-queries) [Manufacturing Modernization](https://www.dreamfactory.com/case-studies/steel-manufacturing-sap-erp-modernization) [Financial Services Investor Portal](https://www.dreamfactory.com/case-studies/financial-services-sql-server-investor-portal) [Non-Profit Partner Data Sharing](https://www.dreamfactory.com/case-studies/non-profit-sql-server-partner-data-sharing) [Professional Services Exec Dashboards](https://www.dreamfactory.com/case-studies/professional-services-erp-dashboards) [Education HR and External Data Sharing](https://www.dreamfactory.com/case-studies/education-student-hr-sql-server-mysql-external-data-sharing)

Industries

#### [Healthcare HIPAA-grade APIs across EHR, claims, and labs.](https://www.dreamfactory.com/use-cases/healthcare)

#### [Financial Services Portfolios, partners, and portals on one layer.](https://www.dreamfactory.com/use-cases/financial-services)

#### [Government Modernize mainframes without re-platforming.](https://www.dreamfactory.com/use-cases/government)

#### [Manufacturing SAP, MES, and shop-floor data, governed.](https://www.dreamfactory.com/use-cases/manufacturing)

SQL Database

[SQL SQL Server](https://www.dreamfactory.com/connectors/sql-server) [OR Oracle](https://www.dreamfactory.com/connectors/oracle) [PG PostgreSQL](https://www.dreamfactory.com/connectors/postgresql) [My MySQL](https://www.dreamfactory.com/connectors/mysql)

NoSQL & Docs

[Dy DynamoDB](https://www.dreamfactory.com/connectors/dynamodb) [Do DocumentDB](https://www.dreamfactory.com/connectors/azure-documentdb) [Mo MongoDB](https://www.dreamfactory.com/connectors/mongodb) [Cb CouchDB](https://www.dreamfactory.com/connectors/couch-db)

Cloud Warehouses

[S3 S3](https://www.dreamfactory.com/connectors/amazon-s3) [Ab Azureblob](https://www.dreamfactory.com/connectors/azure-blob) [FS FTP/SFTP](https://www.dreamfactory.com/connectors/ftp-sftp) [LS Local Storage](https://www.dreamfactory.com/connectors/local-storage)

C & SaaS

[Sf Salesforce](https://www.dreamfactory.com/connectors/salesforce) [API REST / SOAP](https://www.dreamfactory.com/connectors/soap-to-rest)

[See all 30+ connectors](https://www.dreamfactory.com/connectors)

[![back arrow](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/orange-arrow.svg) Blog](https://blog.dreamfactory.com/)

# What are REST endpoints that JOIN table data?

 by Jason Gilmore

![calendar icon](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/calendar-icon.svg) September 26, 2023

Table of contents

RECOMMENDED ARTICLES

- [A Complete Guide to API Generation](https://blog.dreamfactory.com/a-complete-guide-to-api-generation)
- [10 Best API Management Tools](https://blog.dreamfactory.com/what-is-api-management-a-brief-overview-of-api-management-concepts-and-tools)
- [Creating a Microsoft SQL Server API in Less Than 5 minutes with DreamFactory](https://blog.dreamfactory.com/creating-a-microsoft-sql-server-api-in-less-than-5-minutes-with-dreamfactory)
- [Hasura vs. DreamFactory: A Comprehensive Comparison](https://blog.dreamfactory.com/hasura-vs-dreamfactory)
- [Build A Snowflake REST API in Less Than 5 Minutes](https://blog.dreamfactory.com/generate-a-snowflake-rest-api-in-less-than-5-minutes)

REST endpoints that join table data typically allow you to retrieve and combine information from multiple tables or data sources in a single API call. These endpoints enable complex queries and data aggregations, often using JOIN operations, to return a unified dataset, simplifying data retrieval and reducing the need for multiple requests and manual data processing. They are commonly used in database systems and data analytics platforms to efficiently access and manipulate interconnected data.

Experienced coders can implement the fundamental CRUD (create, retrieve, update, delete) interactions pretty quickly, particularly when using a capable web framework such as [Laravel](https://laravel.com/) or [Ruby on Rails](https://rubyonrails.org/).

So far, so good. However, when building an API-driven application, the real work often lies beyond these boilerplate features. For instance, how would the API handle a table join? What about a nested update in which both an employee profile and his associated department assignment were changed? How are endpoints responsible for manipulating multiple tables wrapping the queries into a transaction to ensure the queries are treated as an atomic operation?

[![DreamFactory_blog_CTA_163x200@2x-May-07-2024-08-15-34-3229-AM](https://no-cache.hubspot.com/cta/default/44870387/interactive-167690643360.png)](https://blog.dreamfactory.com/hs/cta/wi/redirect?encryptedPayload=AVxigLKSP6Iq4ooV65RbVMyaeHOm9C5rAObFb5IL0m7axjFukTNYsYSBi8R0HxOi2gnPZY0oXKwCkxyRF%2B0%2Ff7R4JGHD25h5kwRgN6ccYGGnyx%2BcQ0h4wTCZYnULYUz%2F%2FVDESHxP8UiW46IdkIDr3dNnH4wx%2Fd0MNhVO2f%2BewoozFF4znLJfhg%3D%3D&webInteractiveContentId=167690643360&portalId=44870387)

The DreamFactory team has spent a tremendous amount of time and effort solving these sorts of challenges with REST endpoints. In this first of a several part series covering DreamFactory's advanced database API features, I'll walk you through several examples demonstrating platform capabilities in this regards.

## Joining Related Data in a RESTful Web API

The DreamFactory platform is best known for its ability to auto-generate full-featured APIs with REST endpoints for a wide variety of databases ([20 at last count, including MS SQL Server, MySQL, Oracle, and MongoDB](https://www.dreamfactory.com/hub/categories/databases/) - [watch this video to learn more](https://www.youtube.com/watch?v=FPoXJLK1wkw)). Beyond generating endpoints for interacting with tables, views, and stored procedures, DreamFactory will also scan the database schema for foreign key relationships, creating keyword aliases which can be passed along as parameters to produce a table join.

For example, after generating an API for the [official MySQL example database](https://dev.mysql.com/doc/employee/en/sakila-structure.html), DreamFactory will recognize six foreign key relationships associated with the employees table:

![DreamFactory auto-generates JOIN aliases for foreign key relationships](https://blog.dreamfactory.com/hubfs/Imported_Blog_Media/schema-relationships-1024x532.png)

DreamFactory auto-generates JOIN aliases for foreign key relationships

Note the type column: DreamFactory can recognize the four common types of table relationships, including "belongs to", "has one", "has many", and "many to many". In the case of the employees table, DreamFactory recognizes two "many to many" and four "has many" relationships.

The name column identifies the auto-generated join alias. You will use these aliases to execute SQL joins via an API call. For instance, we can retrieve all records found in the employees table via this URI:

```
/api/v2/mysql/_table/employees
```

This call will return the table record in JSON format. Here is some example output:

```
{
    "emp_no": 10001,
    "birth_date": "1953-09-02",
    "first_name": "Georgi",
    "last_name": "Facello",
    "gender": "M",
    "hire_date": "1986-06-26"
},
{
    "emp_no": 10002,
    "birth_date": "1964-06-03",
    "first_name": "Bezalel",
    "last_name": "Simmels",
    "gender": "F",
    "hire_date": "1985-11-21"
},
```

Now suppose we want to additionally retrieve each employee's assigned department. We can pass the `related` key with the 'departments\_by\_dept\_emp\` alias to the API call:

```
/api/v2/mysql/_table/employees?related=departments_by_dept_emp
```

This will produce the following response:

```
{
  "emp_no": 10001,
  "birth_date": "1953-09-02",
  "first_name": "Georgi",
  "last_name": "Facello",
  "gender": "M",
  "hire_date": "1986-06-26",
  "departments_by_dept_emp": [
    {
      "dept_no": "d005",
      "dept_name": "Development"
    }
  ]
},
{
  "emp_no": 10002,
  "birth_date": "1964-06-03",
  "first_name": "Bezalel",
  "last_name": "Simmels",
  "gender": "F",
  "hire_date": "1985-11-21",
  "departments_by_dept_emp": [
    {
      "dept_no": "d007",
      "dept_name": "Sales"
    }
  ]
}
```

## Joining Multiple Tables Using a REST API

DreamFactory also supports the ability to join more than two tables together. This is accomplished by adding more than one alias to the `related` parameter. The following example will join the employee record associated with the primary key 10001 with the departments and salaries tables:

```
/api/v2/mysql/_table/employees/10001?related=departments_by_dept_emp,salaries_by_emp_no
```

This will produce the following record:

```
{
  "emp_no": 10001,
  "birth_date": "1953-09-02",
  "first_name": "Georgi",
  "last_name": "Facello",
  "gender": "M",
  "hire_date": "2019-06-26",
  "departments_by_dept_emp": [
    {
      "dept_no": "d005",
      "dept_name": "Development"
    }
  ],
  "salaries_by_emp_no": [
    {
      "emp_no": 10001,
      "salary": 60117,
      "from_date": "2019-06-26",
      "to_date": "2020-06-26"
    },
    {
      "emp_no": 10001,
      "salary": 65433,
      "from_date": "2020-06-27",
      "to_date": "2021-06-26"
    }
  ]
}
```

If you want to join all available tables together, you can pass an asterisk to the `related` parameter:

```
/api/v2/mysql/_table/employees/10001?related=*
```

## REST endpoints: Overriding the Default Join Alias

You can override the default join aliases to a more preferable string. For instance you might want to instead use `departments` instead of `departments_by_dept_emp`. You can update the alias by navigating to DreamFactory's Schema tab, choosing the API, then choosing the join alias under the `Relationships` section and making the desired modification. Once done your URI will look like this:

```
/api/v2/mysql/_table/employees?related=departments
```

The output will look like this:

```
{
  "emp_no": 10001,
  "birth_date": "1953-09-02",
  "first_name": "Georgi",
  "last_name": "Facello",
  "gender": "M",
  "hire_date": "1986-06-26",
  "departments": [
    {
      "dept_no": "d005",
      "dept_name": "Development"
    }
  ]
},
{
  "emp_no": 10002,
  "birth_date": "1964-06-02",
  "first_name": "Bezalel",
  "last_name": "Simmel",
  "gender": "F",
  "hire_date": "1985-11-21",
  "departments": [
    {
      "dept_no": "d007",
      "dept_name": "Sales"
    }
  ]
}
```

[![Did you know you can generate a full-featured, documented, and secure REST API in minutes using DreamFactory? Sign up for our free 14 day hosted trial to learn how! Our guided tour will show you how to create an API using an example MySQL database provided to you as part of the trial!](https://no-cache.hubspot.com/cta/default/44870387/interactive-167716561074.png)](https://blog.dreamfactory.com/hs/cta/wi/redirect?encryptedPayload=AVxigLJKzZGFL3TJvs4Fs6%2FFq1urSBut9xCm%2BOBurb42oW7slLghsiQ5YzREFn95WMW3JoDzdK%2B6hcRZYAGzfRNUe5ZJBYGC8K7zAK2D7huzBkNo9r%2BviD8G82ZqV1dEEO2mVVkDvBs1ldHqkPqcbDju%2FH9M0PpL%2BTQos91hp9K%2FZ%2Fyn6A%3D%3D&webInteractiveContentId=167716561074&portalId=44870387)

## Conclusion

As this post demonstrated, DreamFactory can reduce a great deal of tedious work associated with API-driven data interfaces. In the next installment you'll learn how a DreamFactory-generated API & REST endpoints can perform nested and bulk inserts and updates involving multiple tables.

##### Related Reading

[Best Practices for Naming REST API Endpoints](https://blog.dreamfactory.com/best-practices-for-naming-rest-api-endpoints)

Last updated: May 2026 REST API endpoint naming is the practice of choosing consistent, resource-oriented URLs for every operation in your API. Good naming makes an API predictable, easier to integrate, and — increasingly — easier for AI agents to use safely. Bad naming makes every endpoint a ... [Continue reading](https://blog.dreamfactory.com/best-practices-for-naming-rest-api-endpoints)

[![](https://blog.dreamfactory.com/hs-fs/hubfs/raw_assets/public/dreamfactory/images/cropped-Group-46154-32x32.png?width=32&height=32&name=cropped-Group-46154-32x32.png) DreamFactory Software - Blog](https://blog.dreamfactory.com/)

[**Watch the full video: Creating Your First Database API**](https://www.dreamfactory.com/videos/first-database-api)

TAGS: [Database APIs](https://blog.dreamfactory.com/tag/database-apis)

![Jason Gilmore](https://blog.dreamfactory.com/hs-fs/hubfs/e92b7c5571ae1bf1ac6e6326767f35c0.jpeg?width=100&height=100&name=e92b7c5571ae1bf1ac6e6326767f35c0.jpeg)

Jason Gilmore

Jason is the author of almost a dozen books on web development, including most recently Easy Laravel 5, and Beginning PHP and MySQL, 4th Edition. He's the co-founder of the CodeMash Conference, one of the largest software conferences in the Midwestern United States. Jason serves as a technical advisor to the boards of several technology startups. His free time is spent playing with his kids and reading.

 Stay Connected with   
 The Connector Newsletter!

 Subscribe to stay up-to-date with DreamFactory's latest product updates, API best practices, and tech humor in your inbox.

[![Dreamfactory Logo](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/megamenu/Megamenu-logo.svg)](https://www.dreamfactory.com/)

[Call Sales +1 (415) 993-5877](tel:+14159935877)

Open – Mon–Fri 9–5 PT

[FREE 30 Minute Demo](https://www.dreamfactory.com/demo)

#### Follow us

- [GitHub](https://github.com/dreamfactorysoftware/dreamfactory)
- [Facebook](https://www.facebook.com/dfsoftwareinc/)
- [X (Twitter)](https://twitter.com/dfsoftwareinc)
- [LinkedIn](https://www.linkedin.com/company/dreamfactory-software)
- [YouTube](https://www.youtube.com/c/dreamfactorysoftware)

### Features

[Features](https://www.dreamfactory.com/features) [Self hosted](https://www.dreamfactory.com/features#self) [API Generation](https://www.dreamfactory.com/features#api) [Security](https://www.dreamfactory.com/features#secure) [Customization](https://www.dreamfactory.com/features#custom) [Pricing](https://www.dreamfactory.com/pricing)

### Installers

[Linux](https://www.dreamfactory.com/features#installer) [Docker](https://www.dreamfactory.com/features#installer) [Kubernetes](https://www.dreamfactory.com/features#installer)

### API Resources

[Documentation](https://docs.dreamfactory.com/) [Case Studies](https://www.dreamfactory.com/stories) [White Papers](https://www.dreamfactory.com/resources/whitepapers) [Academy](https://www.dreamfactory.com/academy) [API Calculator](https://calculator.dreamfactory.com) [Open Source](https://github.com/dreamfactorysoftware)

### Company

[Blog](https://blog.dreamfactory.com/) [Hub](https://www.dreamfactory.com/hub) [About us](https://www.dreamfactory.com/about) [Partners](https://www.dreamfactory.com/partners) [Support](https://www.dreamfactory.com/support) [Connectors](https://www.dreamfactory.com/connectors) [Contact Us](https://www.dreamfactory.com/demo)

 © 2025 DreamFactory. All rights reserved.

[Terms of Use](https://www.dreamfactory.com/terms-of-use) [Privacy Policy](https://www.dreamfactory.com/privacy-policy) [LLMs](https://www.dreamfactory.com/llms.txt)

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Jason Gilmore",
    "url" : "https://blog.dreamfactory.com/author/jason-gilmore"
  },
  "dateModified" : "2024-05-23T07:11:20.702Z",
  "datePublished" : "2023-09-26T20:04:48.000Z",
  "headline" : "What are REST endpoints that JOIN table data?",
  "image" : [ "https://blog.dreamfactory.com/hubfs/Imported_Blog_Media/What-are-REST-endpoints-that-JOIN-table-data.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://blog.dreamfactory.com/rest-endpoints-that-join-table-data",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://blog.dreamfactory.com/hubfs/DreamFactory%20-%20Orange%20-%20Transparent-1.png"
    }
  }
}
```