Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Left outer join error
I resolved this issue by creating a hold file. One of my join files was an inner join which created the problem. Traci- tracisell
- Post #2
- Forum: Information Builders, Inc.: WebFOCUS
-
Make duplicate row records into columns
Hello everyone, I'm pretty new to webfocus and I have a database file that contains duplicate row values for courses a student is currently taking. My webfocus report lists per row: Student #, Course 1, Section 1 Student #, Course 2, Section 2 Student #, Course 3, Section 3 and I would like...- tracisell
- Thread
- Replies: 1
- Forum: Information Builders, Inc.: WebFOCUS
-
Left outer join error
I am getting this error when trying to run my program, and am not sure what is wrong with my join. I am trying to join the tables so that I get output even if the conjoining key is not in each file. (FOC32456) ANSI-COMPLIANCE ENFORCED BY CHANGING OUTER JOIN TO INNER Here are my joins: SET...- tracisell
- Thread
- Replies: 2
- Forum: Information Builders, Inc.: WebFOCUS
