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

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

New No-Code Track! 🚀start learning today!

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

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

🤑 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
      • • 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
    • Showing results for:
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Inner Joins
    • Close
  • Ra Bha
    Ra Bha
    2,201 Points

    If the tables are aliased to md and mk, how come the column names don't change when query is run?

    Posted on Dec 15, 2020 by Ra Bha
    Ra Bha
    2,201 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Inner Joins

    1 Answer

  • Jesse Dispoto
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Jesse Dispoto
    Front End Web Development Techdegree Graduate 14,538 Points

    Join works in this example without specifying the columns to join

    Posted on Aug 8, 2019 by Jesse Dispoto
    .a{fill-rule:evenodd;}techdegree seal-36
    Jesse Dispoto
    Front End Web Development Techdegree Graduate 14,538 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Inner Joins

    0 Answers

  • Ankur Saxena
    Ankur Saxena
    681 Points

    Which is better in terms of Query execution and performance metrics?

    Posted on Jun 2, 2019 by Ankur Saxena
    Ankur Saxena
    681 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Inner Joins

    1 Answer

  • Sarah Freitas
    Sarah Freitas
    2,469 Points

    Inner Join

    Posted on May 27, 2018 by Sarah Freitas
    Sarah Freitas
    2,469 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Inner Joins

    1 Answer

  • Mehiret Abdissa
    Mehiret Abdissa
    415 Points

    Inner Join

    Posted on Jan 26, 2018 by Mehiret Abdissa
    Mehiret Abdissa
    415 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Inner Joins

    1 Answer

  • orange sky
    seal-mask
    .a{fill-rule:evenodd;}techdegree
    orange sky
    Front End Web Development Techdegree Student 4,945 Points

    Inner join

    Posted on Nov 8, 2016 by orange sky
    .a{fill-rule:evenodd;}techdegree
    orange sky
    Front End Web Development Techdegree Student 4,945 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Inner Joins

    2 Answers

  • nb11
    nb11
    17,552 Points

    Joins??

    Posted on Sep 28, 2016 by nb11
    nb11
    17,552 Points
    • Databases
    • Querying Relational Databases
    • Joining Table Data with SQL
    • Inner Joins

    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.