Do I have to have equal number of records in each table to combine them?
- From: david.isaacks@xxxxxxxxxxx
- Date: 20 Apr 2006 11:37:13 -0700
I have two tables. One for Feb and one for Mar. The fields are
identiical in each table however the records are not equal in number.
For instance one table Output_MAR_2006 has 107,000 records and
Output_FEB_2006 has 48,000 records. For one field in each table
(Facility VISN) I want to combine to run a report to find out the
trend. The field is a number field, and in the report I need to count a
certian number of records which equal (22) and compare it against FEB
records which equal (22). So I thought it I just add both tables into
one and only select the (Facility VISN) field I could do the math in
the report. However, when I combine them, the the data gets all messed
up. Plus I can never get the report to open. It's like both colums have
to be the same lenght.
David
.
- Follow-Ups:
- Prev by Date: Re: How do I prompt query for several parameters?
- Next by Date: Re: Reading .txt file for a long long sql string
- Previous by thread: Re: How do I prompt query for several parameters?
- Next by thread: Re: Do I have to have equal number of records in each table to combine them?
- Index(es):
Relevant Pages
|
