Question:

How to total from one table data to another table data in one table

by Guest10734  |  earlier

0 LIKES UnLike

how to add data's from one table to fetch and how to calculated the data in msaccess

 Tags:

   Report

1 ANSWERS


  1. SELECT SUM(totals) FROM

    (SELECT SUM(prices) totals FROM Table1

    UNION SELECT SUM(prices) totals FROM Table2)

Question Stats

Latest activity: earlier.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.