MS SQL

  • Thread starter Thread starter Gregc.
  • Start date Start date
G

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
 
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
Click to expand...

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]
 
Back
Top