Specify a filter on one table, and SQL Server will use defined relationships to add joins that extend this filter to other ...