16/224
\begin{frame}
  \frametitle{Ambiguous Attribute References}
  
  \structureExercisesResults
  \medskip

  Consider the following query:
  \begin{tcenter}
    \begin{code}{\textwidth}{}
      \small
      \BUseVerbatim{query}
    \end{code}
  \end{tcenter}
  \pause
  In the \sql{select} clause \sql{number} is ambiguous.
  \pause

  \begin{alertblock}{}
    Although forced to be equal by the join condition, SQL
    requires the user to specify whether \sql{number} refers to \sql{R} or \sql{E}.
  \end{alertblock}

  The unambiguity check is purely \emph{syntactic} and does
  not depend on the query semantics.
  \bigskip
\end{frame}