One other thing. Something roughly like the following (I haven't tested it,
but its MySQL for SELECT INTO and a sub SELECT)
INSERT INTO masterTable (ipAdd)
SELECT slaveTable.ipAdd
FROM slaveTable
LEFT JOIN masterTable
ON slaveTable.ipAdd = masterTable.ipAdd
WHERE masterTable.ipAdd IS NULL;
would be perfect, but as I am working across DSNs its not really feasible
AFAIK. Would selecting into a file and then reading this file back out for
inserts be the plan?
Cheers
Mark
______________
Mark Stanton
Web Production
Gruden Pty Ltd
Tel: 9956 6388
Mob: 0410 458 201
Fax: 9956 8433
www.gruden.com
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
