Name: Anonymous 2005-09-02 4:35
Hi /prog, say I have a table with two columns:
- Employee name [primary key]
- Employee data (address, etc.)
- Chief [foreign key to this table]
How could I construct a SELECT statement to get all employees that, for example, have the same address as their boss?
- Employee name [primary key]
- Employee data (address, etc.)
- Chief [foreign key to this table]
How could I construct a SELECT statement to get all employees that, for example, have the same address as their boss?