Is this ok?
UPDATE table1
SET table1.field1 = table2.field1
SELECT table1.field1, table1.field2, table2.field1, table2.field2,
table2.field3
FROM table1, table2
WHERE table1.field2 BETWEEN table2.field2 AND table2.field3
HAVING table1.field1 IS NULL;
I know there's a lot of rules about the update clause, but I find the
documentation not satisfying. Can I use all these clasues in an update sql
statement, assuming 3.22.32 on RH 6.2
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
