08 How to Join two tables in a SQL query

preview_player
Показать описание
Рекомендации по теме
Комментарии
Автор

HI! I've been following your playlists in learning how to do all this. In my version of the website I am trying to make, I have a "Trip Name" where your "Joke Title" is, and then I want to display a list of people who are associated with my "trip Name" in the accordion style, where your "answer" is. Currently, I JOINED my 2 tables on the Foreign Key, but the result pops out the "trip Name" how ever many times for there are people, and there is one name per time. I want this to only show the trip once, and have multiple people underneath. Essentially, I need to figure out how to "echo" the whole column of people who are associated with that trip. Any suggestions? Love your stuff. Thanks!

FlushItGolf