>I have a problem getting my syntax down on the following problem:
>
>I have a table which contains a status code,an employee code,and a resolution code. I want to create a view that is an INNER JOIN between the master table and three subtables (status,employee,resolution) containing a descriptive field from each subtable in the result view.
>
>Can somebody post a good example of this? Thanks

does the 'master record' have to have all 3 fields filled?

select S.status_desc, E.emp_desc, R.res_desc from ;
    master_table M, status S, employee E, resolution R where ;
    M.status_code = S.status_code and ;
    M.emp_code    = E.emp_code    and ;
    M.res_code    = R.res_code into cursor does_this_work