Welcome to the Treehouse Community
Looking to learn something new?
Luke McGuigan14,228 Points
Trouble with challenge 2 of Multiple Conditionals (Integrating PHP with Databases)
Hello, the following is the SQL query I've used for this task, whilst it's pulling only the title from the media title in regards to the lastname of 'Tolkien', it seems the issue where this isn't being accepted if that duplicates of each item are being produced.
SELECT title FROM Media me JOIN Media_People m, People p ON m.people_id = p.people_id WHERE fullname LIKE '%Tolkien';
I was wondering if anyone could provide assistance on this.
Simon Coates28,693 Points
SELECT m.title FROM Media m JOIN Media_People mp ON m.media_id = mp.media_id JOIN People p ON mp.people_id = p.people_id WHERE p.fullname like '%Tolkien';
Does anybody know the answer to task 3 of this same challenge? Really struggling on that one