DB recursive relations question

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?

>>4
alot of non standard sql language think they're so clever by including reptition and recursion tools in their SQL DBMS but if you think a loop is a good idea in an sql query you're probably doing it wrong