⚡ CYBER NOVEMBER SALE ⚡ 50% off any plan for 6 months, exclusive to new subscribers.

Join the Treehouse affiliate program and earn 25% recurring commission!

  • Treehouse Logo
  • Plans
    Chevron
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
  • Library
    Chevron
    • All Courses
    • Tracks
    • College Credit
  • Techdegree
    Chevron
    • Overview
    • Front End Development
    • Full Stack JavaScript
    • Data Analysis
    • UX Design
    • Python
  • Community
    Chevron
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
  • Resources
    Chevron
    • Career Toolbox
    • CodeForward
    • Free Treehouse Near Me
    • Jobs
    • Blog
    • Support
    • About
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks College Credit
  • Overview Front End Web Development Full Stack JavaScript Python Development Data Analysis UX Design
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Career Toolbox CodeForward Free Treehouse Near Me Jobs Blog Support About
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • APIs
      • • Coding for Kids
      • • College Credit
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Game Development
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • No-Code
      • • PHP
      • • Professional Growth
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
      • • Swift
      • • Vibe Coding
  • Rushabha Jain
    seal-mask
    PLUS
    .a{fill-rule:evenodd;}techdegree
    Rushabha Jain
    Front End Web Development Techdegree Student 9,859 Points

    cte vs join performance

    Posted April 18, 2021 7:01am by Rushabha Jain
    .a{fill-rule:evenodd;}techdegree
    Rushabha Jain
    Front End Web Development Techdegree Student 9,859 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    1 Answer

  • Jordan young
    PLUS
    Jordan young
    Courses Plus Student 5,277 Points

    Hi. I did a totally different query, but generated the same result. Is there a preference for either method?

    Posted September 24, 2020 3:02pm by Jordan young
    Jordan young
    Courses Plus Student 5,277 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    1 Answer

  • kevin hudson
    PLUS
    kevin hudson
    Courses Plus Student 11,987 Points

    Is it a bad approach to use subqueries over CTE and JOINING?

    Posted April 8, 2019 6:20pm by kevin hudson
    kevin hudson
    Courses Plus Student 11,987 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    2 Answers

  • Harris Handoko
    Harris Handoko
    3,932 Points

    Question on order of joining tables

    Posted February 3, 2019 11:34pm by Harris Handoko
    Harris Handoko
    3,932 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    2 Answers

  • György Varga
    György Varga
    19,198 Points

    Case sensitivity

    Posted July 28, 2017 6:39am by György Varga
    György Varga
    19,198 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    2 Answers

  • Greg Kaleka
    Greg Kaleka
    39,021 Points

    More Subqueries!

    Posted July 21, 2017 9:46pm by Greg Kaleka
    Greg Kaleka
    39,021 Points
    • Databases
    • SQL Reporting by Example
    • Day 1: Joining Tables
    • 7th Grade Science

    4 Answers

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.

    Treehouse

  • About
  • Blog
  • Careers
  • Community
  • Stories
  • Shop
  • Contact
  • Gift Card

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Affiliates
  • Perks
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2025 Treehouse Island, Inc.