Database Reference
In-Depth Information
Figure 9.18
Conigure connection.
10. On the Deine Custom Statements or Stored Procedure page, click the
Query Builder
button. In the Query Builder dialog, add the tables
CLASS
,
COURSE
,
SEMESTER
,
DAYS
, and
TIMEBLOCK
. hen, select the columns
ClassID
,
CourseName
,
TimeBlock
,
Week Day
,
Semester
, and
Credit
. Click
Execute Query
to make sure
that the query is working properly as shown in Figure 9.19. hen, click
OK
.
Figure 9.19
Create SELECT statement.