Display all employee names and their department names.
Use the NamanNavan (N2) Corporation database tables to design the following queries. (Use the spooling method to capture all queries and results in the CHAP7SP1.LST file.)
```
SQL> SELECT LNAME, FNAME, DEPTNAME
2 FROM EMPLOYEE E, DEPT D
3 WHERE E.DEPTID = D.DEPTID;
LNAME FNAME DEPTNAME
--------------- --------------- ------------
SMITH JOHN FINANCE
HOUSTON LARRY MARKETING
ROBERTS SANDI FINANCE
MCCALL ALEX INFOSYS
DEV DEREK INFOSYS
SHAW JINKU
SALES
GARNER STANLEY SALES
CHEN SUNNY FINANCE
8 ROWS SELECTED.
```
You might also like to view...
Flow control statements cannot be used for parallel execution.
Answer the following statement true (T) or false (F)
____________________ allows you to add or edit controls, change properties, and view the underlying report structure but not the data.
Fill in the blank(s) with the appropriate word(s).
?
What will be an ideal response?
Which of the following defines how data is placed on a carrier signal?
A. Modulation B. Multiplexing C. Digitization D. Adaptation