References Between Tables
Here is a meaningful query involving the two tables:
SELECT login, name FROM students, departments
WHERE dept=abbrev
In sqlplus:
SQL> select login, name from students, departments
2 where dept=abbrev ;
LOGIN NAME
----------------- --------------------------------------------------------------------------
Fulay Computer Science
zyr98210 Computer Science
jin0328 Computer Science
wcao Computational Science and Information Technology
Flora Electrical Engineering
5 rows selected