Joining tables

You can create a join between tables by selecting the key of the master table and while maintaining the mouse buton, point to the key of the detail table. PHsPeed will draw a connecting line to show the relationship. The above sample shows a complex query with several links.

Visibilty of fields

By checking and unchecking the checkbox before the fields you can select which fields are used and which not. If you have duplicate fields then the system will generate a sequence number.

courseid -> courseid_1

As the field is already selected you might run into issues on your form as there are more specs then fields. Therefore it is advised to:

Uncheck the duplicate field
Use an AS alias (see later) and assign a custom unique name.

Changing Join Type

By default PHsPeed generates a standard join. It is possible to change it into inner/outer joins. There is some discussion on the web regarding efficiency and speed of the query, but we haven’t found real evidence. Click on the link to select and use the right mouse button to open the options. Select ‘link options’ and a new dialog will open for you to select the join type.