I had this big doubt from begining of my sql journey.
Why do we need a foreign key? is there any relationship between foreign key and joins? What is the whole point of marking a key foreign key?

Someone pls explain me (everyone here in this post) in detail, thanks!