Perhatikan tabel EMPLOYEE, DEPARTMENT, dan DEPT_LOCATION berikut:

Query SQL mana yang paling tepat untuk menampilkan nama karyawan, nama departemen, dan lokasi departemen tempat mereka bekerja ?

Question

Perhatikan tabel EMPLOYEE, DEPARTMENT, dan DEPT_LOCATION berikut: 
  
   
 Query SQL mana yang paling tepat untuk menampilkan  nama karyawan, nama departemen, dan lokasi departemen tempat mereka bekerja ?

Answer

SELECT E.Fname, E.Lname, D.Dname, DL.Dlocation 
 FROM EMPLOYEE E  JOIN DEPARTMENT D ON E.Dno = D.Dnumber;

Answer

SELECT E.Fname, E.Lname, D.Dname, DL.Dlocation 
 FROM EMPLOYEE E  JOIN DEPARTMENT D ON E.Dno = D.Dnumber JOIN DEPT_LOCATIONS DL ON D.Dnumber = DL.Dnumber;

Answer

SELECT E.Fname, E.Lname, DL.Dlocation 
 FROM EMPLOYEE E  JOIN DEPT_LOCATIONS DL ON E.Dno = DL.Dnumber;

Answer

SELECT Fname, Lname, Dname, Dlocation  
 FROM EMPLOYEE, DEPARTMENT, DEPT_LOCATIONS;

Crowdly

Perhatikan tabel EMPLOYEE, DEPARTMENT, dan DEPT_LOCATION berikut: Query...

Want instant access to all verified answers on scele.cs.ui.ac.id?