complete view statement