Spoke too soon - it works in the query test but then gives me an error message when I try to save it: "An item with the same key has already been added."
SELECT DISTINCT
csori#,
cscas#,
oacas#,
csstat,
oaofic,
oaasst,
oaasby,
oaaymd,
tedesc,
e.ombdg#,
e.omlnam,
e.omfnam,
s.ombdg#...