If you want to create a single filter that utilizes criteria from multiple tables in...

Filter Types in Query Designer

A Query Advanced Filter is used to define filter conditions across multiple tables in a single query. This is necessary when the criteria involve fields from different data sources.

Why Other Options are Incorrect

A (Query Scope filter): Used to limit data based on scope, but it does not combine criteria across multiple tables.

B (Table Simple filter): Applies filters only to a single table.

D (Table Advanced filter): Applies advanced criteria but only within a single table.

References

SAP SuccessFactors Query Designer Documentation