The LINQ keyword Joins. This keyword gives you the ability to join data properties, database tables, etc.., that don’t have any kind of association. For example say you have tables with ID properties in two database tables without any kind of association from a database perspective. What the join keyword can do is join the two ID properties of the tables together to run queries on.
There are three types of Joins I’ll be showing here. Normal Joins, group joins, and cross joins. All of them will be using query syntax. I’ll be demonstrating method syntax in some later examples.
Again if you’re confused about the terminology of the different query types use this. Query = Comprehension Syntax, Lambda = Method Syntax.