Hi, Doug!
What about:
INSERT into Inventory (ItemCode,Description)
SELECT *DISTINCT* ItemCode,Description +
FROM Orders +
WHERE ItemCode in (SELECT ItemCode from NewItems)
(sent from Moto Z)
On Fri, Aug 3, 2018, 9:00 PM Doug Hamilton wrote:
> My SQL brain cell is stumped.
>
> We have a
My SQL brain cell is stumped.
We have a bunch of orders coming in, most of the items are already in
the db, but, naturally, sometimes they are not and I want to add them on
the fly.
Incoming orders might look like:
Order# ItemCode Description
101 AAA Framus
102 BBB
Doesn't work but, looking more carefully at the help file I notice that only a
small number of components (variable and DB fields) and a small number of EEPs
(Enter, Exit, and Click) are eligible for custom set-up like this. So I think
I'm out of luck with this technique.--Larry
On
3 matches
Mail list logo