Anybody see anything wrong with this query?

[jxaxmxixn]

For some reason it fails...
I think i'm just not in the zone to see what I'm doing wrong....

INSERT INTO [shipped_items] ([ID], [item_id], [shipment_id], [item_weight], [entry_date], [exit_date], [by_user], [customer_id])
SELECT [shipping_items.ID], [shipping_items.item_id], [shipping_items.shipment_id], [shipping_items.item_weight], [shipping_items.entry_date], [shipping_items.exit_date], [shipping_items.by_user], [shipment_list.customer_id]
FROM [shipping_items]
LEFT JOIN [shipment_list] ON [shipping_items.shipment_id] = [shipment_list.ID]
WHERE [shipping_items.shipment_id] = 69;

 

[namliam]

[shipping_items.item_id]
Should be
[shipping_items].[item_id]

And that all over

 

[jxaxmxixn]

[shipping_items.item_id]
Should be
[shipping_items].[item_id]

And that all over

okay, let me try it... i'll be right back (thanks in advance)
i'm assuming i should do this for everything... right???

 

[jxaxmxixn]

SOLVED! thanks!!!

Although, I think it only required me to do this after the ON...

Ehh... Problem solved! Thanks again!