| |
| | [No title] |
 | | Select SerialNum, Rate From WorksOn Where PersID = [Var3] Suppose here the PersID is 33333: db2 => select serialnum, rate from workson where persid = 33333 SERIALNUM RATE ----------- ------ 454189 11.00 642894 11.00 2 record(s) selected. |
 | | Select Name From People Where PersID in (Select PersID From Techs Where CertLevel > [Var5]) Suppose the user has select ‘3’ from the dropdown box: db2 => select name from people where persid in (select persid from techs where certlevel > 3) NAME -------------------- Sweeney, Christopher Peterson, Chris 2 record(s) selected. |
 | | Select Name From People Where PersID in (Select PersID From Employees Where Availability = [Var6]) Suppose the user selected the ‘1’ radio button: db2 => select name from people where persid in (select persid from employees where availability = 1) NAME -------------------- Caputo, Michael Peterson, Chris Winston, George 3 record(s) selected. |
| www.personal.psu.edu /users/c/l/clp232/queries.doc (1460 words) |
|