>>I have create a VIEW with CREATE SQL VIEW.
>>After using the VIEW, I return to my table.
>>I then create the same VIEW using the same name myview), but I am getting the previous VIEWS results? What do I do?
>Are you creating the view each time with a different WHERE condition?

yes