M
mrelam
I have a union query that attempts to union 3 tables. Each table has
140 fields. The table structures are identical, so all the field
names are the same in all tables. I get the error message "Too many
fields defined." The maximum number of fields in a table is 255, so
why can't there be 140 in a query? What is the maximum number of
fields that can be in a union query?
140 fields. The table structures are identical, so all the field
names are the same in all tables. I get the error message "Too many
fields defined." The maximum number of fields in a table is 255, so
why can't there be 140 in a query? What is the maximum number of
fields that can be in a union query?