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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by USX01
-
SQL sub-query troubles
Thanks Rob, however in the where clause WHERE (A, B) in (SELECT A, B FROM C WHERE) NEED TO BE: SELECT A, B FROM X WHERE (A, B) in (SELECT Y,Z FROM C WHERE)- USX01
- Post #3
- Forum: Oracle: All versions
-
SQL sub-query troubles
I have stared at this for a while to no avail. I'm not sure why this isn't working,the errror i'm getting is a "invalid sql statement" error. Here's the rough SQL statement: select A, B from X where A,B in (select Y,Z from C where ....) Thanks inadvance- USX01
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
Report Column Folder
I've noticed that after 290 items in the query (calculations or data warehouse item) anything after that number will not appear in the Report Coulmn Folder under the Available Components box. Curious if this just bug or if others have had a similar problem. I've found that by rearranging the...- USX01
- Thread
- Replies: 0
- Forum: Cognos solutions
-
Impromptu Query Data Limit??
When adding Query Data Items, Report --> Query then adding calculations to the Query data, there seems to be limit. I can add the data items, however when you try to add them into a definition of a certain query data item (Available Components, the Report Columns folder), it will not be in that...- USX01
- Thread
- Replies: 0
- Forum: Cognos solutions
