Databases Reference
In-Depth Information
Figure 6-35.
Selecting report columns
6.
Set
Table/View Name
to
STATUS_LOOKUP
, and wait for the page to reload.
Select the
STATUS
column in the
Select Columns
list to the left, and move it to the
Columns Selected
list by clicking the
>
icon.
7.
From the
Columns Selected
list, remove the
TICKETS.STATUS_ID
column by selecting it
and clicking the
<
icon.
8.
9.
Click
Next
to verify the join conditions. You see the dialog in Figure
6-36
.
Figure 6-36.
Joining the tables