Simple yet important concept on views where multiple tables are involved regardless of indexes, primary or foreign keys. Thanks for the question.