对表Data进行查询:
SELECT DISTINCTT1.f1, T2.f2, T3.f3, T4.f4, T5.f5, T6.f6, T7.f7, T8.f8
FROM data AS T1,data AS T2, data AS T3, data AS T4, data AS T5,data AS T6, data AS T7, data AST8
WHERE T1.f1 is notnull and T2.f2 is not null and T3.f3 is not null and T4.f4 is not null andT5.f5 is not null and T6.f6 is not null and T7.f7 is not null and T8.f8is not null;
怎么把查询结果保存在新表中啊
SELECT DISTINCTT1.f1, T2.f2, T3.f3, T4.f4, T5.f5, T6.f6, T7.f7, T8.f8
FROM data AS T1,data AS T2, data AS T3, data AS T4, data AS T5,data AS T6, data AS T7, data AST8
WHERE T1.f1 is notnull and T2.f2 is not null and T3.f3 is not null and T4.f4 is not null andT5.f5 is not null and T6.f6 is not null and T7.f7 is not null and T8.f8is not null;
怎么把查询结果保存在新表中啊