IWETHEY v. 0.3.0
|
TODO
1,095 registered users | 1
active user
| 0 LpH |
Statistics
Login
|
Create New User
Welcome to IWETHEY!
IWETHEY Home
/
IWETHEY Board
/
Databases Forum
/
I've learnt so much SQL since I last played with Access...
Post #234,164
by
static
11/14/05 9:45:08 PM
Reply
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."
Post #236,681
by
tablizer
11/30/05 7:24:59 PM
Reply
Learning SQL via Access like lrning human rghts from Sadam
________________
oop.ismad.com
Updating a table
- (
pwhysall
)
- (5)
- Nov. 14, 2005, 06:27:05 AM EST
Some possibilities
- (
ChrisR
)
- (1)
- Nov. 14, 2005, 10:33:45 AM EST
Much thanks
- (
pwhysall
)
- Nov. 14, 2005, 10:34:31 AM EST
I've learnt so much SQL since I last played with Access...
- (
static
)
- (1)
- Nov. 14, 2005, 09:45:08 PM EST
Learning SQL via Access like lrning human rghts from Sadam
-NT
- (
tablizer
)
- Nov. 30, 2005, 07:24:59 PM EST
Why not just use an Access append query
- (
jbrabeck
)
- Nov. 15, 2005, 09:50:32 AM EST
i
we
they
.org
Their business was zero and it was shrinking.
105 ms