| Assembly | SqlServer.Rules.dll |
| Namespace | SqlServer.Rules.Design |
| Class | MissingJoinPredicateRule |
| Id | SRD0020 |
| Friendly Name | Incomplete or missing JOIN predicate |
| Category | Design |
| Ignorable | false |
| Applicable Types | Procedure |
| Scalar Function | |
| Table Valued Function | |
| View |
The query has issues with the join clause. It is either missing a backing foreign key or the join is missing one or more columns.
Make sure you have all the columns for the JOIN relationship as conditions in the ON clause