Error in Delete Query
- From: djkc <djkc@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 18 Aug 2008 08:41:00 -0700
I made a query to check socials from an active tbl against socials from an
inactive table. I run the query with a left join so that both fields are
equal to show me all the inactive socials that are in the active tbl. I need
these deleted out of the inactive tbl so I change my query type from select
to delete and recieve the error specify the table you want the records to be
deleted from. Anyone know how to get around this?
.
- Follow-Ups:
- Re: Error in Delete Query
- From: John W . Vinson
- RE: Error in Delete Query
- From: djkc
- Re: Error in Delete Query
- Prev by Date: RE: Update table data
- Next by Date: RE: Update table data
- Previous by thread: Update table data
- Next by thread: RE: Error in Delete Query
- Index(es):