The statement executed outside of the view is the one below, filter added to both of the select statements.

SELECT accountnumber FROM agents2009 WHERE accountnumber = ''QOT039365'

UNION ALL

SELECT accountnumber FROM agents WHERE accountnumber = ''QOT039365'

Hope this help clears up the question.