mysql常用查询测试及答案: 参考链接： http://blog.sina.com.cn/s/blog_767d65530101861c.html -------------------创建如下表---------------------- 1.创建表 CREATE TABLE student ( id INT(10) NOT NULL UNIQUE PRIMARY KEY , name VARCHAR(20) NOT NULL , sex VARCHAR(4), birth YEAR, d
sql 语句中where条件和jion on条件的区别
与有很大的差别，请注意！
SELECT TBL_SchemaDetail.MaterialNo, TBL_StockMaterial.SalePrice
FROM TBL_StockMaterial RIGHT OUTER JOIN
TBL_SchemaDetail ON
TBL_StockMaterial.MaterialNo = TBL_SchemaDetail.MaterialNo AND
TBL_Schem
