Union between unequal fields?

  • Thread starter Thread starter Razor
  • Start date Start date
R

Razor

Hi,

How can I union a table (100 fields) with a query (4
fields, all 4 matching the table's fields) such that the
resulting union has nulls is the remaining 96 fields for
the records contributed to the union by the query.

I tried creating placeholders for the remaining 96 fields
in the query ([FieldName]: Null) but when I try unioning
the 100-field table to the 100-field query, it tells me
that there are too many fields defined.

This dataset is completely de-normalized. It is the
result of a feed and I do not want to solve this proble
through normalization.

Thanks!

Regards,
Razor
 
it tells me
that there are too many fields defined.
Click to expand...

There are. You're limited to 255 fields in a Query.
This dataset is completely de-normalized. It is the
result of a feed and I do not want to solve this proble
through normalization.
Click to expand...

Then I see no way to accomplish what you ask.
 
I'm not sure I understand your problem.

Is your query something like:

SELECT FieldA, FieldB, FieldC, FieldD, Field5, Field6
FROM TableA
UNION
SELECT Field1, Field2, Field3, Field4, NULL, NULL
FROM QueryOne

That should work as far as I know. If you exceed the 255 field limit then you
should have a problem, but based on your description, I don't see that happening.
 
Back
Top