
November 19th, 2003, 02:59 PM
|
|
almost there....
|
|
Join Date: Nov 2003
Location: A Red Glitter Coffin
Posts: 140
Time spent in forums: 10 h 28 m 24 sec
Reputation Power: 0
|
|
|
tables of REFs
I have a nested table which is a table of REF values to a type of member
I can insert like this :
INSERT INTO TABLE(SELECT playerlist FROM hometeams h
WHERE h.teamname ='MENS A')
SELECT REF(s)
FROM studentmembers s
WHERE s.stuid = 51702114 OR s.stuid = 12345678;
How do i get it out? i.e.
SELECT ? FROM TABLE(SELECT playerlist FROM hometeams WHERE id = 1) p
please help, needed urgently!
|