This has been raised previously, marked as solved, but really wasn't.   The SAS DI join transformation has a union option.  This should allow multiple selections and where clauses to produce a single result.  I can find no way to do this.   If I want a list of distinct names from two tables the SQL it should produce would look like:   Select name from employee where dept = 'abc' union select name from prospect where city = 'denver'   It only allows one map, one select, and one where clause.   I don't really want to use the set operator as I then want this to be a sub-query in the join transformation, not separate.   How can I do this? Thanks.   ... View more