0

Can anyone tell me the answer of following question in brief?
What role does the concept of foreign key play when specifying the join operations?

John
  • 19
  • 4
  • 1
    None. And all joins are meaningful. [Whether a particular join on a particular column set involves a foreign key is just not germane to understanding the meaning of a query.](https://stackoverflow.com/a/24909854/3404097) But what role do you think it plays? And what do you mean by "the most common types of meaningful join operations"? Please read & act on hits googling 'stackexchange homework' & the downvote arrow mouseover text. – philipxy Sep 03 '18 at 09:50

1 Answers1

0

Most of the time we use primary key of one table as foreign key in another table so if we use foreign key in join then it will optimize your queries.

Shivam
  • 116
  • 6