Find umatched query question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a find unmatched query currently in use in my billback design
program. My problem is, subsequent queries I create from this (and this one
too), are by default non-updateable.

Is there a way I can change this, so that I can update these records?

Thanks
 
Hi,



Change the beginning of the query to read


DELETE DISTINCTROW tableToDeleteFrom.* FROM table1 LEFT JOIN table2 ON
.... WHERE ...

assuming the "SELECT" query is:

SELECT tableToDeleteFrom.* FROM table1 LEFT JOIN table2 ON ... WHERE ...




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top