On to page three. Now that the tables are all setup it is time to introduce the 3 basic types of joins to our audience. When the users of the tutorial we are creating runs the queries there is going to be a problem since the natural join will produce more resulted than are returned by default. To get around this problem the tag 'SQLExecutionOptions' is used. On the previous page you had a look at the option available in the Ad hoc SQL. This tag lets you get all available options within the Ad Hoc on page change. With that in mind option set on one page of a tutorial will be reverted to the default if no new setting are given for the transitioning page.

Available options:

Steps to complete: