to Pc 狂迷:
我上面的贴子有误,FF 从2.10 起已支持较完整的Insert、Update 和 Delete 语句,以下的 Insert 语句是没问题的。
1、 INSERT INTO teachers (teacher#, teacher_name) SELECT DISTINCT student#, student_name FROM students , enrolls WHERE students.student# = enrolls.student# AND grade = 4;
2、 INSERT INTO BLOBTgt SELECT ALL FROM BLOBs;
3、 INSERT INTO a SELECT ALL'this should cause a failure', 0, s, 1, bl FROM a WHERE bl IS NOT NULL;
4、 INSERT INTO a (bl) SELECT ALL bl FROM a WHERE bl IS NOT NULL;
----------------------------
例子可看 v2.13 的 Test 包。