Treehouse | Community | Using a Subquery to Create a Temporary Table (Part 2)

✨ 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!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Kenzie Iles
1,773 Points
Error: near "ID": syntax error

Posted on Feb 6, 2023 by Kenzie Iles

Kenzie Iles
1,773 Points
1 Answer
PLUS

Sharina Jones
Courses Plus Student 18,771 Points
Query producing incorrect results

Posted on Feb 20, 2019 by Sharina Jones

Sharina Jones
Courses Plus Student 18,771 Points
2 Answers
Claudio Paladini
13,403 Points
How is this different from a join?

Posted on Apr 4, 2018 by Claudio Paladini

Claudio Paladini
13,403 Points
1 Answer
Abdullah Jassim
4,551 Points
Why does the GROUP BY Function in SQL add more names. It isnt just suppose to cluster together rows together?

Posted on Feb 6, 2018 by Abdullah Jassim

Abdullah Jassim
4,551 Points
1 Answer
Boban Talevski
24,793 Points
Is there a way to write the query as shown in the video without hardcoding the values of LocationID?

Posted on Oct 29, 2017 by Boban Talevski

Boban Talevski
24,793 Points
0 Answers
jlampstack
23,932 Points
Is There a Sales Table?

Posted on Apr 11, 2017 by jlampstack

jlampstack
23,932 Points
1 Answer
Cayo Estevao
2,048 Points
Why location id is = 1?

Posted on Mar 19, 2017 by Cayo Estevao

Cayo Estevao
2,048 Points
1 Answer
John Yzaguirre
22,025 Points
Why does LEFT OUTER JOIN work but JOIN does not?

Posted on Dec 31, 2016 by John Yzaguirre

John Yzaguirre
22,025 Points
2 Answers

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