[log in to unmask] wrote:
: David McConnachie asks:
[snip]
: All 3 files can be linked by one common file.
 
: We have tried altering the weightings and outer join characteristics,
: so far to no avail.
 
Per my reply to the original post to the powerhouse list server I
suggested that he look at using UNION ALL.
 
--
Nigel Campbell            Voice: (613) 738-1338 ext 3016   P.O. Box 9707,Stn.T
Business Intelligence       FAX: (613) 738-0002            3755 Riverside Dr.
Cognos Incorporated    Internet: [log in to unmask]         Ottawa ON K1G 4K9
                      URL: http://www.cognos.com           CANADA