Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Sandro Das Neves
Front End Web Development Techdegree Graduate 23,426 Pointswhat am I doing wrong ?
hello, that's my code. SELECT * FROM results WHERE away_team = "Hessle" AND away_team > 18; i receive a error message saying I'm not selecting results table.
Sandro Das Neves
Front End Web Development Techdegree Graduate 23,426 Pointsyeah sorry I Think it was already linked ,here it is: https://teamtreehouse.com/library/sql-basics/finding-the-data-you-want/filtering-on-more-than-one-condition-2
1 Answer
Seth Kroger
56,413 PointsWhere you have away_team > 18 should be score > 18.
Sandro Das Neves
Front End Web Development Techdegree Graduate 23,426 PointsOMG i need some rest thank you very much.
Seth Kroger
56,413 PointsSeth Kroger
56,413 PointsIt would be a help if you could link to the challenge you're on. Unfortunately database questions don't get automatically linked to their challenges like others.
I do notice you have the away_team column as a condition twice, but once as a string/text and once as a number. I think the second condition will be a different column.