>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