Treehouse | Community | Inner Joins

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

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Sarah Freitas
2,469 Points
Inner Join

Posted May 27, 2018 12:39am by Sarah Freitas

Sarah Freitas
2,469 Points
1 Answer
Kareem Jeiroudi
14,984 Points
Last Challenge Task 4 of 4 Bummer: Your query didn't return all columns from the Sale table for who's CustomerIDs .....

Posted May 26, 2018 6:05pm by Kareem Jeiroudi

Kareem Jeiroudi
14,984 Points
1 Answer
Kareem Jeiroudi
14,984 Points
Does `Union`, `Intersect` or `Except` imply that the columns are of the same datatype?

Posted May 26, 2018 1:12am by Kareem Jeiroudi

Kareem Jeiroudi
14,984 Points
- Databases
1 Answer
Troy Erby
6,332 Points
Trouble with Set Operations

Posted May 25, 2018 5:49pm by Troy Erby

Troy Erby
6,332 Points
1 Answer
Jameel Abbess
1,402 Points
Error in Question On Reporting with SQL

Posted May 25, 2018 4:24pm by Jameel Abbess

Jameel Abbess
1,402 Points
1 Answer
Don Macarthur
28,430 Points
MAMP / phpMyAdmin Not Picking Up Table Data

Posted May 25, 2018 12:22am by Don Macarthur

Don Macarthur
28,430 Points
- Databases
0 Answers
Kimberly Johns
909 Points
Reporting with SQL Challenge Task

Posted May 24, 2018 6:08pm by Kimberly Johns

Kimberly Johns
909 Points
2 Answers
Troy Erby
6,332 Points
Trouble inserting Primary Key

Posted May 24, 2018 5:29pm by Troy Erby

Troy Erby
6,332 Points
2 Answers
James Ramsey
15,948 Points
SHIFT + ENTER

Posted May 24, 2018 2:09pm by James Ramsey

James Ramsey
15,948 Points
2 Answers
Fathima Fas-ha
6,847 Points
Reporting with SQL

Posted May 24, 2018 9:47am by Fathima Fas-ha

Fathima Fas-ha
6,847 Points
1 Answer
Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
Trouble with Challenge on Min Max values for Query

Posted May 24, 2018 3:15am by Edgardo Tupiño

Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
1 Answer
Noel Thurau
1,021 Points
I'm having trouble with 2 of the quizzes.

Posted May 23, 2018 9:57pm by Noel Thurau

Noel Thurau
1,021 Points
1 Answer
Kareem Jeiroudi
14,984 Points
Anyone had the problem that it kept adding the values 500 and -10, even after setting `PRAGMA FOREIGN_KEYS = on;`

Posted May 23, 2018 5:51pm by Kareem Jeiroudi

Kareem Jeiroudi
14,984 Points
4 Answers
Mark Mazur Lussenburg
25,338 Points
Challenge task 2 relational databases SET OPERATIONS

Posted May 23, 2018 2:42pm by Mark Mazur Lussenburg

Mark Mazur Lussenburg
25,338 Points
2 Answers
Amelia Groen
6,144 Points
Using find() returns nothing with ObjectID

Posted May 23, 2018 2:17pm by Amelia Groen

Amelia Groen
6,144 Points
1 Answer
Ali Ahmadian
11,474 Points
what im doing wrong?please Help!

Posted May 22, 2018 8:56pm by Ali Ahmadian

Ali Ahmadian
11,474 Points
1 Answer
Troy Erby
6,332 Points
Having trouble with Reporting SQL with the REPLACE function

Posted May 22, 2018 1:29pm by Troy Erby

Troy Erby
6,332 Points
1 Answer
Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
I tried with this query "SELECT SUBSTR(first_name, 1, 1) || " " || last_name AS initial FROM customers;" and return me "

Posted May 22, 2018 2:54am by Edgardo Tupiño

Edgardo Tupiño
Front End Web Development Techdegree Graduate 32,244 Points
2 Answers
Stevan Lay
8,306 Points
What is the correct syntax here?

Posted May 21, 2018 1:42am by Stevan Lay

Stevan Lay
8,306 Points
1 Answer
Terri Valentine
23,034 Points
SELECT COUNT(*) AS shipped_yesterday FROM orders WHERE status = "shipped" AND DATE("now", "-1 day")

Posted May 20, 2018 12:40am by Terri Valentine

Terri Valentine
23,034 Points
1 Answer
Alexander Solberg
14,350 Points
Can't enter "{}" in MongoDB Shell

Posted May 19, 2018 8:23pm by Alexander Solberg

Alexander Solberg
14,350 Points
0 Answers
John Tester
3,366 Points
SQL Reporting ecommerce challenge; concatenate

Posted May 14, 2018 2:19pm by John Tester

John Tester
3,366 Points
1 Answer
Hani AMer
946 Points
Live Data Preview

Posted May 14, 2018 7:46am by Hani AMer

Hani AMer
946 Points
- Databases
1 Answer
Ahmed Mohamed Fouad
11,735 Points
My Code for this lesson using CTE

Posted May 14, 2018 5:12am by Ahmed Mohamed Fouad

Ahmed Mohamed Fouad
11,735 Points
0 Answers
Ahmed Mohamed Fouad
11,735 Points
When Writing "Join" only, is it the inner, left, or outer one ?

Posted May 13, 2018 11:52pm by Ahmed Mohamed Fouad

Ahmed Mohamed Fouad
11,735 Points
- Databases
- Using Multiple CTEs in a Query
1 Answer
Philip Schultz
11,437 Points
Why does UNION ALL work in this case and not just UNION

Posted May 13, 2018 1:10pm by Philip Schultz

Philip Schultz
11,437 Points
2 Answers
Jason Tabaczynski
3,177 Points
Can't create table with the CREATE TABLE command

Posted May 12, 2018 6:56pm by Jason Tabaczynski

Jason Tabaczynski
3,177 Points
1 Answer
Ahmed Mohamed Fouad
11,735 Points
SQL Playground - Set Operations Practice (second question)

Posted May 10, 2018 9:01pm by Ahmed Mohamed Fouad

Ahmed Mohamed Fouad
11,735 Points
7 Answers
Valerie Don
1,438 Points
Not sure what I'm missing or misplacing? SELECT*FROM results WHERE away_team = "Hessle" > 18 AND away_score > 18;

Posted May 10, 2018 6:08pm by Valerie Don

Valerie Don
1,438 Points
- Databases
1 Answer
Patricia Hector
42,902 Points
Issue with DB working locally with phpmyadmin [SOLVED]

Posted May 10, 2018 1:01pm by Patricia Hector

Patricia Hector
42,902 Points
0 Answers

Prev Page 42 of 104 Next

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