Like most magic, set-up takes work

Like most magic, set-up takes work and time, but the magic occurs with a single phrase. The command box at the top of the page is blank. In it type “SELECT * FROM classes WHERE emp_number = :emp_ number;” (without the quotation marks, be certain to include a space on both sides of the equals sign). Press control-enter to execute the command. SELECT * FROM classes is SQL for display the contents of all fields in classes. The WHERE sets conditions on what to display. Here, emp_ number from classes must equal emp_number from the employee database. The colon indicates that you are entering a dynamic parameter.[7] When you click on a record in the employee table of the upper screen, the classes table displayed will change to match that employee.