I have been using the following query to join “select … from plays, songs where plays.song_id=songs.id”. How is this any different from the query provided in hint which is “select … from plays join songs on plays.song_id=songs.id”? And if it is not, why can’t I move forward?
I have the same question as the reply above me, but it hadn’t been answered, and it’s been awhile so I thought I would ask again with some formatted code.
SELECT plays.user_id AS 'user',
plays.play_date AS 'date',
songs.title AS 'song name'
FROM plays
JOIN songs
ON plays.song_id = songs.id
;
and
SELECT plays.user_id AS 'user',
plays.play_date AS 'date',
songs.title AS 'song name'
FROM plays
JOIN songs
WHERE plays.song_id = songs.id
;