Large UNION query trunctates data in DB field

[Jason Salas]

I ran into errors recently when I tried running a large UNION query (about
6,900 news articles) in a desktop Access database, that will eventually be
migrated to SQL Server. I've got two tables, each having the same typed
fields. I joined then through the following query:

SELECT ID,Name,Body FROM Table1 UNION SELECT ID,Name,Body FROM Table2;

The problem was that in the resultant table containing the conjoined
records, one of the fields (Body, a MEMO field) copies only the first 250
characters or so, truncating the rest of the data.

I was thinking this might have something to do with telling Access how to
type the data when copying it over. Is there a way to explicitly tell a
query the data type of each field to be used so that the data can be copied
over properly?

Thanks!

[Jason Salas]

I figured it out...I needed to use UNION ALL


"Jason Salas" <jason@kuam.com> wrote in message
news:3f405b69@tnews.web.devx.com...
> I ran into errors recently when I tried running a large UNION query (about
> 6,900 news articles) in a desktop Access database, that will eventually be
> migrated to SQL Server. I've got two tables, each having the same typed
> fields. I joined then through the following query:
>
> SELECT ID,Name,Body FROM Table1 UNION SELECT ID,Name,Body FROM Table2;
>
> The problem was that in the resultant table containing the conjoined
> records, one of the fields (Body, a MEMO field) copies only the first 250
> characters or so, truncating the rest of the data.
>
> I was thinking this might have something to do with telling Access how to
> type the data when copying it over. Is there a way to explicitly tell a
> query the data type of each field to be used so that the data can be
copied
> over properly?
>
> Thanks!
>
>