Re: SQL Statement Problem

Is everyone having trouble doing their homework or are they just dare I say lazy.
"Calvin" <calvin_at_isidasia.com.hk> wrote in message news:9mke9u$5jc$1_at_news.hk.linkage.net...
> Dear all !
> 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 - 14:42:46 CEST