arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 07:16
- Joined
- May 7, 2009
- Messages
- 19,246
Code:
INSERT INTO Inventory (Item, price )
SELECT [Inventory Ellen made].Item, [Inventory Ellen made].price
FROM [Inventory Ellen made]
WHERE [Inventory Ellen made].Item
Not In (SELECT Item FROM Inventory);