((can use Access's 'pass-through' query to utilize Oracle's
functions))
Greetings,
Connect-by clause?? Seriously lost.....any syntax please....
2 tables:
Group_Upload Site_History
------------ ------------
Group_Num Site_Key
Site_Key New_Site_Key
A user will upload a group of Site Keys in the Group_Upload table, and
specify the group using Group_Num. What I need help w/ is as
follows...
(probably using connect by clause??)
If the Tables looked like this:
Site_History | Group_Upload
---------------------- | ---------------------
Site_Key | New_Site_Key | Group_Num | Site_Key
1 | 2 | ABC44 | 1
2 | 3 | |
3 | 4 | |
User specifies Group_Num "ABC44" and the Site_Key in Group_Upload
table was "1", then it would return "4" (don't need 2 or 3 nodes, just
the final "Leaf"...
