could not delete from specified tables

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

Guest

I have two tables with an interjoin. dbo_IMINVLOC_SQL and dbo_IMITMIDX_SQL.
The first is an inventory table based on location. The second is a master
inventory table. I need to delete items form the location files based on
critera from both tables. I'm getting "could not delete from specified
tables" below is the query.

DELETE dbo_IMINVLOC_SQL.*, dbo_IMINVLOC_SQL.item_no,
dbo_IMINVLOC_SQL.qty_on_hand, dbo_IMINVLOC_SQL.qty_allocated,
dbo_IMINVLOC_SQL.qty_bkord, dbo_IMINVLOC_SQL.qty_on_ord,
dbo_IMINVLOC_SQL.last_sold_dt, dbo_IMINVLOC_SQL.qty_sold_ytd,
dbo_IMINVLOC_SQL.active_ords, dbo_IMITMIDX_SQL.activity_cd
FROM dbo_IMITMIDX_SQL INNER JOIN dbo_IMINVLOC_SQL ON
dbo_IMITMIDX_SQL.item_no = dbo_IMINVLOC_SQL.item_no
WHERE (((dbo_IMINVLOC_SQL.qty_on_hand)<1) AND
((dbo_IMINVLOC_SQL.qty_allocated)<1) AND ((dbo_IMINVLOC_SQL.qty_bkord)<1) AND
((dbo_IMINVLOC_SQL.qty_on_ord)<1) AND
((dbo_IMINVLOC_SQL.last_sold_dt)<20040101) AND
((dbo_IMINVLOC_SQL.qty_sold_ytd)<1) AND ((dbo_IMINVLOC_SQL.active_ords) Is
Null) AND ((dbo_IMITMIDX_SQL.activity_cd)="O"));

Thanks in advance for you help!
 
Also, you already posted this once at 2:25 quit clogging up the newsgroup
with your thread. When someone has an answer for you they will post it.
 
Rick the repeated post was not done intentionally. The post interface was
not functionally correctly and would close before the post was finished. I
didn't realize the post had made it. Sorry!
 
Back
Top