todm
Posts: 1
|
Posted: 09/29/2005, 9:36 AM |
|
I have 3 list of values (RSVP, SM, AE). I need to set a variable for RSVP so I can use this variable in WHERE clause of my SQL statement for the SM list of values.
I then need to set a variable for the SM value to use in my WHERE clause of my SQL statement for the AE list of values.
I am using ASP. SQL statement would be as follows:
select SM
from Employee_Hierarchy
where RSVP={RSVP_Variable_Name}
group by SM
order by SM
_________________
Tod Marburger
Sr. Specialist - AT&T |
|
|
|