Can you provide an example of a LINQ join involving three tables in C#? What type of key (primary, foreign, composite, natural) is being used to relate the tables in this example?