Forum Discussion
Filter rows in Query editor
Hello, I want to create 2 new queries (query B, query C) from a single query (query A) in query editor. In query B I want to filter "male" (Gender="male) and on the other query (query C) I want t...
Hi Anonymous,
I will give you the example for 1 table but just replicate the steps.
On the query editor
1 - On query A right click and choose reference (one with the clip icon) doing referece will allow you to update all your tables when you make changes to query A
2 - Filter out the column or columns you need or change or add columns as needed
Regards,
MFelix
Easiest way is just to copy query A to query B and C and in those queries, filter as necessary.