以下面的SQL语句为例： SQL ="SELECT c_firstname, c_lastname, c_email FROM customers WHERE c_email IS NOT NULL AND c_purchase = '1' OR c_purchase = '2' AND c_lastname LIKE 'A%'"
多行语句 在SQL语句不好懂的情况下，你不妨把整个语句分解为多行代码，然后在现有变量基础上逐步增加查询语句的各个组成部分并把它存在同一变量内： SQL = "SELECT c_firstname, c_lastname, c_emailaddress, c_phone" SQL = SQL & " FROM customers" SQL = SQL & " WHERE c_firstname LIKE 'A%' and c_emailaddress NOT NULL" SQL = SQL & " ORDER BY c_lastname, c_firstname" 到了最后一句，SQL变量就包含了以下的完整SELECT 语句： "SELECT c_firstname, c_lastname, c_emailaddress, c_phone FROM customers WHERE c_firstname LIKE 'A%' and c_emailaddress NO NULL ORDER BY c_lastname, c_firstname"
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
