Nick,
> RIGHT JOIN is only supported with mergejoinable join conditions
Woof! Talk about destruction testing. You have ... let's see ... a
three-column right join on two right-joined tables. If you ahve
uncovered a bug, I wouldn't be surprised.
However, are you sure you want RIGHT OUTER JOINS and not LEFT? Try
re-organizing the query as LEFT JOINS, and see if it works.
create view demo
as select case_data.case_id, case_disposition_code.case_disp_global_desc, local_case_type.global_case_type_desc from ( case_data left
join case_disposition_code on case_data.case_disp_local_code
= case_disposition_code.case_disp_local_code ) LEFT JOIN local_case_type
ON (( local_case_type.court_id
= case_data.court_id ) and ( local_case_type.local_case_subtype_code
= case_data.local_case_type_code ) and ( local_case_type.local_case_subtype_code
= case_data.local_case_subtype_code ));
If that doesn't work, try making the case_data and case_disposition_code
join into a subselect.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete
informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small
businesses fax 621-2533 and non-profit organizations. San Francisco
