join连接--特定关键字
SELECT * FROM table1(表1)JOIN table2(表2) ON table1.field(表1的字段) = table2.field(表2的字段);
判断字符是否为NULL或空
SELECT * FROM table1 WHERE table1.field IS NULL OR table1.field LIKE '';