view statement

In theory, how complex could a View statement get? Discuss whether there would be an advantage to chain multiple views under another view. Where does it stop? Explain the possibilities, and support your ideas with specific examples.