title: APEX - Compare value against current user ID
body: <p>I'm attempting to create a report that will present filtered information depending on the user ID. Lecturers will be able to login to the system and will see all of the modules that they are the leader of, the login ID is the same as the lecturer code that is used to define lecturer code in the module table.</p>
  
  <p>Here is my SQL query.</p>
  
  <pre><code>SELECT m.module_code, m.module_name, m.lecturer_code, 
  m.module_number_assessments, m.module_moderator FROM module m, lecturer l 
  WHERE m.lecturer_code = [Select l.lecturer_code from lecturer l where 
  l.lecturer_code = UserInfo.getUserId()];
  </code></pre>
  
  <p>I receive the following error "Query cannot be parsed, please check the syntax of your query. (ORA-00936: missing expression)" when attempting to use this as the source for the report.</p>
  
  <p>I am fairly new to APEX. Any ideas why this code is invalid?</p>