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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ReportSmith and SQL Union and Enterprise V4
Solved my own problem. I forgot to remove ORDER BY clause from each SQL statement and move it to the end. The UNION works when the ORDER BY is at the end. SELECT "PER"."SSN", RPAD("MED"."PLAN_TYPE",6,' ') AS TYPE, RPAD("MED"."BENEFIT_PLAN",6,' ') AS PLAN, RPAD("MED"."COVRG_CD",2,'...- hoxrider
- Post #2
- Forum: Strategic Reporting Systems(SRS): ReportSmith
-
ReportSmith and SQL Union and Enterprise V4
Can the SQL Union function be used within the ReportSmith SQL window? I am not having any luck trying to get my two separate SQL queries to work when I union them. Note - each query works separately. Any examples of the SQL Union that work within ReportSmith would be appreciated.- hoxrider
- Thread
- Replies: 1
- Forum: Strategic Reporting Systems(SRS): ReportSmith
