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!
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!