Binding source filtering data

Question

Hi, one table with two columns is data source of binding source. We want to filter data first my “Name”, and after that by “City”.

Name	City
John	London
John	New York
Jim	London

bindingSource.Filter="Name = 'John'";

Result:

Name	City
John	London
John	New York

If another filter is applied (WITHOUT bindingSource.RemoveFilter())

bindingSource.Filter="City = 'London'";

Result:

Name	City
John	London
Jim	London

My question is: If once binding source is filtered and filter is not removed, why second filter is not applied only on already filtered data?

if first filter filtered data once and is applied second filter on filtered data why we have not situation like

bindingSource.Filter="Name ='John' AND City = 'London'";