[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: composite key in lookup

Raymond,

Just string together the columns which makeup the composite key:

--------------------------------------------------

load-lookup name=salary_lookup
            table=s_emp
            key=emp_id||project_id
            return_value=salary
            where=salary < 1000000

....

begin-select
a.emp_id||b.project_id &key

   move &key to $key
   lookup salary_lookup $return_value $key

from table1 a
   , table2 b
....
end-select

--------------------------------------------------

Wes Bailey
Associate Consultant
Coopers & Lybrand Consulting
1100 Louisiana St., Suite 4100
Houston, TX  77002