3/8 Foreign Key Lesson


I am not able to understand the result that I am getting when I am doing the exercise with the code line:

SELECT albums.name, albums.year, artists.name FROM albums, artists;

What is the result for this command?


It's a bit silly replying to my own ask but I got the answer and I thought I shall leave it for someone who wants to know. The command is a deliberate instruction to pull a gibberish set of data since the next lesson helps us clear it up.


Thanks for adding this. I too spent 5 minutes wondering why it had outputted gibberish (assuming it was my mistake) before finding the answer in your post.