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

Notice: Workspaces are undergoing maintenance and are temporarily unavailable.

🚀 In our NEW AI Bootcamp you'll build a working app in 28 days, no experience required. Free to all subscription levels.

✨ 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 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,794 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,794 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.