I have the problem on this example ?
eg. I have 2 table one is employee and other is department
employee (Enum, Name, Address, SuperEnum, Dnum)
department (Dnum, Dname, depdate)
in employee :
enum is primary key (Employee Number),
SuperEnum is foreign key (Supervisor's Employee Number),
Dnum is foreign key (Department Number)
in department :
Dnum is primary key (Department Number)
if I want list the employee's name and supervisor's name for all employees
in the department "D004" (eg. in department have one of the department
number equal D004).
Can I use one SQL statement to do it? or I need use Join function to join
two table?
Received on Thu Aug 30 2001 - 06:11:17 CEST
