DappLooker Docs
  • 👋Welcome
  • Data APIs for AI
    • Overview
    • Changelog
    • API Authentication
    • API Endpoints
      • GET: Crypto Token Market Data
      • GET: List of All Tokens
      • GET: Multi-Timeframe Technical Analysis
      • GET: Agent Details
      • POST: AI-Powered Query via NLQ
    • Best Practices
    • Conclusion
  • DappLooker Analytics
    • 🗃️Products
      • 📶Analytics
        • 🔎Browse and Search data
        • 📈Creating Charts
          • No-Code Charts
          • SQL Charts
        • 🔢Custom Values
        • 📊Dashboards
          • Create Dashboard
          • Add Charts to Dashboard
          • Discover Page
          • Link dashboard to another dashboard
          • Adding Filters to Dashboard
            • Time Filter
        • ♻️Convert No-Code to SQL
        • 🔗Making Charts and Dashboards Public
      • 🔍Subgraph Analyzer
      • ✨AI Studio
        • AI Studio API Support
      • 🤖DataBOT
        • 🎮Discord Bot
        • ▶️Telegram Bot
        • 🌐Connect with Leading Networks and dApps
      • 🔑DappLooker SDK
        • 🔎Tracking API Usage
    • 🌐Supported Networks
      • Blockchain Data
      • Smart Contracts
      • Subgraphs
      • SubQuery
      • Offchain Data Sources
    • 📲Registering Data
      • My Dashboard Overview
      • Smart Contracts
      • Subgraph
      • Subquery
      • Off-Chain Integration
    • 🔖Featured Projects
    • 🎯Features
      • XRay Feature
      • Filtering
      • Summarize
      • Downloading
        • Download Chart Data
      • Editor Panel
        • Preview Chart
        • Joining Data
        • Types Of Join Data
        • Sorting
        • Row Limit
        • Convert to models
        • Duplicate a Chart
        • New Collection
      • Creating Custom Column and Custom Expressions
      • 📷Screenshot
      • 🗃️Collections
        • Browse Collection
        • Personal Collection
        • Team Collection
    • ⛓️Smart Contract Live Query
    • 🔔Push Notifications
      • 👀Where to view notifications?
      • 📰Push x MetaMask Snaps
    • 👨‍⚖️Case Studies
      • 1️⃣Community Updates
      • 2️⃣DeFi Reports
      • 3️⃣On-Chain & Off-Chain Analysis
      • 4️⃣User Retention Analysis
      • 5️⃣DappLooker Telegram Bot
      • 6️⃣Subgraph Powered No-Code Dashboards
      • 7️⃣API Use Case: Beamswap
      • 8️⃣Embedding Use Case: GRTDataHub
    • 💰Pricing
      • Pricing Breakdown
      • Discounts And Payments
    • 💻Deploy a subgraph on the DappLooker custom node
    • 🥷DappLooker No-code Ninjas Program!
    • 🤝Sponsor With Us
    • 🔗Relevant Resources
    • ☎️Contact Us
  • API Guides
    • Get API Key
    • How to Get an API of a Chart
    • Render Chart or Dashboard as an Image with API
    • Mintbase
      • Individual Store Level APIs
      • Mintbase Protocol Level APIs
    • Nordek Developer APIs
  • Explorers
    • CeloSpy
    • VaraSpy
Powered by GitBook
On this page

Was this helpful?

  1. DappLooker Analytics
  2. Features
  3. Editor Panel

Types Of Join Data

Left outer join: LEFT Join is useful for returning all records from a table, even if there are no matching records in another table. For example, we could use a LEFT JOIN to return all customers, even if they have not placed any orders.

Right outer join: RIGHT JOINs are useful for returning all records from a table, even if there are no matching records in another table. For example, we could use a RIGHT JOIN to return all products that have been ordered, even if the product has been discontinued.

Inner join: An inner join will only return rows that have matching records in both tables. This is the most common type of join, and it is useful for creating charts or dashboards that show only the data that is common to both tables. For example, you could use an inner join to create a chart that shows the orders that have been placed by customers in a particular state.

Full outer join: A full outer join will return all rows from both tables, even if there are no matching rows. This is the least common type of join, but it can be useful for creating charts or dashboards that show all of the data from both tables, even if some of the data is not related to each other. For example, you could use a full outer join to create a chart that shows all of the customers who have placed orders, as well as all of the products that have been ordered, even if some of the customers have not ordered any products and some of the products have not been ordered by any customers.

PreviousJoining DataNextSorting

Last updated 1 year ago

Was this helpful?

🎯