You might try reading the excellent FAQ regarding handling duplicate records. Various techniques can be employed to eliminate duplicates, but you will have to understand the data to use them. Provide more details if you still have a problem.
The different behavior of the SQL outer join could be explained in Impromptu (Version 6) if the Governor prevents outer joins. Check the catalog setting in Impromptu menu - Catalog, User Profiles....and click the Governor tab. The 'outer joins' drop down box should say 'allow'.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.