IWETHEY v. 0.3.0 | TODO
1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New I've learnt so much SQL since I last played with Access...
I'd try something like.

INSERT INTO e SELECT h.* FROM h LEFT JOIN e USING (key) WHERE e.key IS NULL

... which is pretty much Chris's third suggestion.

Wade.
"Insert crowbar. Apply force."
New Learning SQL via Access like lrning human rghts from Sadam
________________
oop.ismad.com
     Updating a table - (pwhysall) - (5)
         Some possibilities - (ChrisR) - (1)
             Much thanks - (pwhysall)
         I've learnt so much SQL since I last played with Access... - (static) - (1)
             Learning SQL via Access like lrning human rghts from Sadam -NT - (tablizer)
         Why not just use an Access append query - (jbrabeck)

Their business was zero and it was shrinking.
105 ms