©Mike Moxcey 1999

Software Select UNION

one statement gets the software info for the call
select where seq=$seq and lk_type='SW'
Puts SELECTED on the option

one gets all other software codes out of the lookup
select from lookup
where lk_code != (select code for $seq)


home next