Has anyone tried to use a union query in CR 8.5. There appears to be little help on this type of query. I've tried to wirite it via the "View SQL" menu item, but it reports an error "cannot find table" when asked to update. When the query is reviewed it attempts to re-write the query originally entered. both tables exist, i.e. you can retrieve information from them separately, but they just don't want to produce a union query. Thanks, Rick