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

New No-Code Track! 🚀 New videos dropping every week—start learning today!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

  • 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
    • Community Projects
    • Live Sessions
    • 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
  • Community Projects Live Sessions 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
      • • Android
      • • 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
  • Alex Flores
    Alex Flores
    7,864 Points

    There has to be an easier way to update tables?

    Posted February 22, 2017 9:31pm by Alex Flores
    Alex Flores
    7,864 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    1 Answer

  • Alex Flores
    Alex Flores
    7,864 Points

    Should I create many different tables and join or fewer tables?

    Posted February 22, 2017 4:22am by Alex Flores
    Alex Flores
    7,864 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    1 Answer

  • Travis Smith
    Travis Smith
    476 Points

    LEFT OUTER JOIN Why would you want to do a LEFT OUTER JOIN versus just returning all of the data in the "Left" column?

    Posted March 16, 2016 11:20pm by Travis Smith
    Travis Smith
    476 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    1 Answer

  • Adiv Abramson
    Adiv Abramson
    6,919 Points

    Why use an alias for genres.name? Isn't using a keyword as a column name bad practice?

    Posted October 12, 2015 3:25pm by Adiv Abramson
    Adiv Abramson
    6,919 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    1 Answer

  • Michael King
    Michael King
    874 Points

    Forgot to add genres_id column

    Posted August 16, 2015 1:24pm by Michael King
    Michael King
    874 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    1 Answer

  • jimmy bryant
    jimmy bryant
    3,747 Points

    Are these SQL statements or MySQL statements?

    Posted August 12, 2015 4:04pm by jimmy bryant
    jimmy bryant
    3,747 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    1 Answer

  • Michael Smith
    PLUS
    Michael Smith
    Courses Plus Student 4,916 Points

    Question about the Statement.

    Posted June 9, 2015 6:04am by Michael Smith
    Michael Smith
    Courses Plus Student 4,916 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    2 Answers

  • Alice Wein
    Alice Wein
    218 Points

    Joining multiple SQL tables

    Posted April 9, 2015 3:46pm by Alice Wein
    Alice Wein
    218 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    2 Answers

  • Diego Salazar
    Diego Salazar
    2,206 Points

    What's the difference between using WHERE and ON in a Select?

    Posted March 22, 2015 6:01pm by Diego Salazar
    Diego Salazar
    2,206 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    2 Answers

  • Joe Ainsworth
    Joe Ainsworth
    13,588 Points

    Schema design to avoid using AS syntax

    Posted January 19, 2015 4:49pm by Joe Ainsworth
    Joe Ainsworth
    13,588 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    0 Answers

  • Phil Ward
    Phil Ward
    4,204 Points

    Where can i get a completed project file for this Database deep dive?

    Posted December 30, 2014 3:13pm by Phil Ward
    Phil Ward
    4,204 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    1 Answer

  • Scott Bergler
    Scott Bergler
    2,211 Points

    JOIN Challenge, Task 1

    Posted December 19, 2014 6:23pm by Scott Bergler
    Scott Bergler
    2,211 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    1 Answer

  • Richard Stringfellow
    Richard Stringfellow
    6,883 Points

    Joining Relational Data Between Tables in SQL

    Posted September 20, 2014 2:10am by Richard Stringfellow
    Richard Stringfellow
    6,883 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    4 Answers

  • John MacDonald
    John MacDonald
    8,593 Points

    I can't get my head around how this SQL Statement works?

    Posted August 9, 2014 11:32pm by John MacDonald
    John MacDonald
    8,593 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    1 Answer

  • Joe Hilton
    PLUS
    Joe Hilton
    Courses Plus Student 4,893 Points

    I've been trying to complete the task for this, and I'm sure I'm putting in the right command but it's not working

    Posted July 31, 2014 8:45am by Joe Hilton
    Joe Hilton
    Courses Plus Student 4,893 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    3 Answers

  • Daniel Araiza
    Daniel Araiza
    601 Points

    Is there a way to watch all the video's at the end (or at any time) with out any interruption for quizzes?

    Posted July 21, 2014 6:29pm by Daniel Araiza
    Daniel Araiza
    601 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    3 Answers

  • Barbara Vega
    seal-mask
    .a{fill-rule:evenodd;}techdegree
    Barbara Vega
    Full Stack JavaScript Techdegree Student 19,486 Points

    Quiz Question

    Posted June 23, 2014 7:26pm by Barbara Vega
    .a{fill-rule:evenodd;}techdegree
    Barbara Vega
    Full Stack JavaScript Techdegree Student 19,486 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    1 Answer

  • Toni Caktas
    Toni Caktas
    16,957 Points

    1/2

    Posted May 25, 2014 11:04am by Toni Caktas
    Toni Caktas
    16,957 Points
    • Development Tools
    • Database Foundations
    • Joining Relational Data Between Tables in SQL
    • Joining Tables and Aliasing

    0 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.