Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon. Entire thread

DB recursive relations question

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?

Name: Anonymous 2005-09-18 23:31

if sql queries were recursive they wouldn't halt.

Newer Posts
Don't change these.
Name: Email:
Entire Thread Thread List