The best replacement for union is union all.

The best alternatives to union are rated as following:
★★★★★  union all
★★★★  confederate
★★★  intersection
★★★  nonunion
★★  join
★★  non union
★★  bank
★  struct
★  confederacy
★  marriage
★  union all oracle
★  union all sql
★  banks
★  bc
★  rpi
  coupling
  right to work
  rpi hockey
  management
  vermont
  open shop
  money gram
  join sql
  jenks
  league
  non-union
  association
  providence
  non-union wages
  structure
  regular bank
  intersection probability
  secession
  union all performance
  league rugby
  rugby league
  union all in sql
  confederate states
  school district
  intersection inequalities
  zaft
  bank for mortgage
  yale hockey
  full outer join
  confederates
  wisconsin whitewater
  marriage rights
  no union
  union all in oracle
  non union wages

Your alternative for union is not listed? Suggest!
Speaking about union, one probably shouldn't forget about order by.

Other search terms related to union and their ratings are:
★★★★★ order by
★★★ distinct
★★★ group by
★ distinct sql
★ where clause
collective bargaining
You have in mind a companion for union and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of union in all years. Click on graph for more.
union
union all
confederate