MS SQL

[Gregc.]

Hi

I'm pretty new at using SQL in MS Access (I think it's referred to as
JetSQL). Anyhow, when I run a query (Union Select) it deletes all the
data from one of the tables. Would anyone know what this is happening?

Greg

 

[John Vinson]

Hi

I'm pretty new at using SQL in MS Access (I think it's referred to as
JetSQL). Anyhow, when I run a query (Union Select) it deletes all the
data from one of the tables. Would anyone know what this is happening?

Greg

No, and I'm all but certain that it ISN'T happening. A UNION query
doesn't even let you *update* any records in its constituent tables,
much less delete them.

Could you post the SQL of the UNION query that you suspect of deleting
data?


John W. Vinson[MVP]