Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Comparing Tables
Forget about the other wish list - just me thinking out loud. Wrong place, wrong time ... bad ciliate! The code works well, but gives me a result like this: --------------------------- table_1 total | <a sum> --------------------------- table_2 total | <a sum> ---------------------------... -
Comparing Tables
Thanks, again. While thinking on this some more, and while I have your attention, let me deepen the inquiry. Suppose I wanted to calculate the two sums, subtract one from the other, display all three values (the two sums and the difference) and test the result? And, suppose I wanted to store... -
Comparing Tables
thanks! works like a charm. Looks like I need to read up on UNION, huh? -
Comparing Tables
Longish post. I have two tables, each about 35,000 rows, derived from different data sources. I need to compare that the calculations based on each of the tables yield equal results. For example, as a quality check, I need to sum "Sales" for each table, and compare the results, which should...
