Help - need equiv of UNION_ALL in view

• colin bradley

  Grasshopper

  Points: 10

  More actions

  December 26, 2002 at 6:58 am

  #58220

  Is it possible to add two (or more) tables using a view?

  The tables are identical but come from different companies relating to transactions for different countries.

  SC010100 = COMPANY 01

  SC010200 = COMPANY 02

  When added together (with several other companies) we can then get grand totals using a report writer such as Crystal Reports.

  In Access there is UNION or UNION_ALL which will do this but I am not aware of a similar function for a view.

  Any suggested workarounds helpful.

• Scorpion_66

  SSCertifiable

  Points: 7891

  More actions

  December 26, 2002 at 8:03 am

  #445145

  Union All works the same in Sql. Just create it using a script rather than the EM, as that's one of the limits of EM.