![Home](../../_derived/home_cmp_pixel110_vbtn.gif)
![Labs](../../_derived/labs.htm_cmp_pixel110_vbtn.gif)
![Tutorials](../../_derived/tutorials.htm_cmp_pixel110_vbtn.gif)
![Known Bugs](../../_derived/bugs.htm_cmp_pixel110_vbtn.gif)
![Schedule](../../_derived/schedule.htm_cmp_pixel110_vbtn.gif)
![Archive](../../_derived/archive.htm_cmp_pixel110_vbtn.gif)
![Members](../../_derived/members.htm_cmp_pixel110_vbtn.gif)
| |
Query By Example
- Click the Relation button.
- Select a relation from the list in the pop-up box.
- Select the attributes you want by clicking on the check boxes.
- Assign any operators or values.
- Click the View button to generate the relation.
|
![](view.gif)
A projection from the Students relation where SNAME and AGE are greater than 21.
- Select the first relation in the join operation.
- Click the Join button.
- Select the second relation in the join operation.
- Select the common attribute.
- Click the View button.
|
![](qbe_join.gif)
A Join of the Students and Grades relations, associated by ID.
|