There is a view in 2000i that was created by the application developer that uses "category" from two tables. When I run the view all is great but if I base a report CR8.5 off it I only get the data from the first "category" since no alias is used in the second.
In PCC, I can look at the view properties but the SQL statement is so large that it doesn't all fit in the window and I cannot change it without errors. Is there any easy way to edit this view?
In PCC, I can look at the view properties but the SQL statement is so large that it doesn't all fit in the window and I cannot change it without errors. Is there any easy way to edit this view?