SELECT * from table B ;
WHERE invno NOT IN (SELECT invno FROM table A) ;
INTO CURSOR Temp
SELECT table A && it's been opened above
APPEND FROM (DBF('Temp'))
USE IN Temp
USE IN table B
Note that this won't handle any structural differences for you; the cursor from the first SELECT will give the records from table B whose invno doesn't already exist in table A, so you could spin through it and do inserts into A.EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater
NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC
The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys