We have thousands of DB2 tables and would prefer to set up relationships on the fly rather than set up all relationships in Framework Manager. With Report Studio you can set the query properties pane to 'Outer Join Allowed (Yes)'. Is there any way to do this in Query Studio so that we can avoid 'cross joins not permitted' error messages?
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query Studio - cross joins not permitted
- Thread starter flagz
- Start date
Similar threads
- Locked
- Question
- Locked
- Question