Deleting Spacific records

  • Thread starter Thread starter Oded Kovach
  • Start date Start date
O

Oded Kovach

Hello there

I have query that find maches between two tables.

Now i need to delete the maching fields from one of the tables.

This query query does not allow add/ update and delete so i can't use it as
delete query

The only way i could use this query to delete the data from the table is by
using this query as subquery in the main delete query action.

THis action is very heavy and when the table has more tnen 1000 records the
query is being stuck

what can i do to solve this?
 
Oded said:
I have query that find maches between two tables.

Now i need to delete the maching fields from one of the tables.

This query query does not allow add/ update and delete so i can't use it as
delete query

The only way i could use this query to delete the data from the table is by
using this query as subquery in the main delete query action.

THis action is very heavy and when the table has more tnen 1000 records the
query is being stuck
Click to expand...


I don't think I followed all that. It might have helped if
you had posted the select query that just finds the matching
records.

Maybe(?) you want something like:

DELETE table2.*
FROM table1 INNER JOIN table2
ON talbe1.flda = tablet.fldb
 
Whell Marshall

The sql you placed is the exacly sql i would neet
when Table1 is the query that give me the mathes fields. Table2 is included
in the maching query. Because of this the query i create is read only query
which i can't use for delete query

can you help me on it?
 
You must have something going on beyond what you've
explained so far, because the query I posted worked for me.

Maybe your query is a little different? Post a Copy/Paste
of your query's SQL and I'll double check it.

On the other hand, maybe you're using something other than
the Jet db engine with different variety of SQL??
 
Back
Top