Буду очень благодарна если кто-то может помочь с Query...

задача такая,
ех.
John Smith
1
а
б
с
2
а
б
с
3
а
б
с

John в организационнои структуре предприятия имеет под собой 3 работника ( 1,2,3). 1,2,3 имеут под собой а,б,с.

Мне нужна Query to Select all under John Smith (вклучая 1,2,3 и все а,б,с).
Так что мой селект даст 12 records в этом примере.

Спасибо за помощь.скажите если вопрос не понятен, я поясню.

Vot chto ia imeu, na sei moment...

SELECT

employee_data_a.oid
approver_name = Employee_data_b.Last_name + " " + EMployee_data_b.first_name,
employee_name = Employee_data_a.Last_name + " " + Employee_data_a.first_name
FROM timecard_approval,
Employee_data Employee_data_a,
Employee_data Employee_data_b
WHERE ( timecard_approval.Employee_Oid *= Employee_data_a.oid ) and
( timecard_approval.Approver_oid *= Employee_data_b.oid )
and
timecard_approval.Type_Sym like 'timecard_approv%'
and timecard_approval.approver_oid = 1564
Order by Approver_name asc, employee_name asc
;

Nuzhno dobavit' k etomu records
gde approver_oid = employee_oid from this query.

Ia nikak ne mogu sostavit' eto, logicheski ponimau, a sintax nikak ...

Spasibo esche raz

Problema v tom chto, tree vinimaetsia is odnoi table, a mne nuzhno is 2x raznix, podskazhite chto ia delau ne tak...

DECLARE @oid int,
@node int

Declare @CurRow int
Declare @RowCount int
Declare @CurOid int


Select @CurRow = 1

/* Creating temporary table for tree storage*/


/* Inserting starting node into the temp table*/
SELECT timecard_approval.employee_oid

into #temp
FROM timecard_approval,
Employee_data Employee_data_a,
Employee_data Employee_data_b
WHERE ( timecard_approval.Employee_Oid *= Employee_data_a.oid ) and
( timecard_approval.Approver_oid *= Employee_data_b.oid )
and
timecard_approval.Type_Sym like 'timecard_approv%'
and timecard_approval.approver_oid = @oid

/* mne kazhetsia problema sdes' no v chem?????*/
Select @RowCount = @@RowCount
DECLARE wCursor Cursor For -- Creates Cursor for Temp Table
Select employee_oid
From #Temp Order By employee_oid ASC

OPEN wCursor

While @CurRow <= @RowCount
BEGIN
FETCH FROM wCursor INTO @CurOid

Insert into #Temp (employee_oid)
Select oid from employee_data where supervisor_oid = @CurOID

SELECT @CurRow = @CurRow + 1
END


Select * From #Temp Order by employee_oid

CLOSE wCursor
DEALLOCATE wCursor

/*#######*/
DROP TABLE #temp
;

spasibo ogromnoe za pomosch.

Sveta