Querydeck Docs
  • 👋Welcome to Query Deck
  • Getting Started
    • 😃Get Started With QueryDeck
      • Quickstart With QueryDeck
    • How It Works?
  • REST
    • Select Method
      • Joins
      • Sorting
        • Ascending/ Descending ordering
        • Dynamic Sorting
      • Filter
        • Dynamic Filtering
        • Groups
        • Exists clause
      • Pagination
        • Offset
        • Limit
    • Insert/Upsert Method
      • Nested Inserts (Joins)
      • Conflicting Columns
    • Update Method
      • Filters
    • Delete Method
    • Authentication
    • Authorization
    • Select by Id
  • GraphQL
    • Introduction to GraphQL in QueryDeck
    • Enabling GraphQL for Columns in QueryDeck
  • Testing Endpoints
Powered by GitBook
On this page
  • Overview
  • Using Joins
  • Testing
  1. REST
  2. Select Method

Joins

PreviousSelect MethodNextSorting

Last updated 1 month ago

Overview

Joins allow you to combine data from multiple tables in QueryDeck to retrieve a unified dataset. Follow these steps to configure joins:

Using Joins

1. Configuring Joins in QueryDeck

  • Open the Joins Editor from the left-side pane.

  • Select the table to join with the base table in the pop up

  • Click on the endpoint on the top left corner to copy it

  • Save the endpoint

Testing

  • Test on Postman or other API testing tools.

  • Paste the endpoint copied and choose GET as the method

  • Click on send to send the request

  • Verify that the response includes combined data from the tables based on the join conditions.

For example, if we join the customer table provided and a hypothetical payments table, a joined result might include customer names alongside their payment histories.