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

🤑 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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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

Posted February 6, 2023 3:07pm by Kenzie Iles

Kenzie Iles
1,773 Points
1 Answer
PLUS

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

Posted February 20, 2019 7:55pm 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 April 4, 2018 3:05pm 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 February 6, 2018 6:37am 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 October 29, 2017 4:35pm by Boban Talevski

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

Posted April 11, 2017 11:42am by jlampstack

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

Posted March 19, 2017 2:18pm 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 December 31, 2016 5:03pm 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.