SELECT MID,MNumber,MGroupID,MSubject,MRealNum,MTime,Materials.MName,Materials.MType,Materials.MUnit FROM MaterialIn ,Materials
WHERE MID=@MID AND Materials.MID=@MID AND MSign=TRUE
WHERE MID=@MID AND Materials.MID=@MID AND MSign=TRUE
WHERE MID=@MID AND Materials.MID=@MID AND MSign=1
-----------------------------------------------^^^
报错:该特定字段'MID'可以参考sql语句中 FROM 了句列表中的多个表!!!
这是怎么回事?
SELECT MID,MNumber,MGroupID,MSubject,MRealNum,MTime,Materials.MName,Materials.MType,Materials.MUnit FROM MaterialIn ,Materials
WHERE MID=@MID AND Materials.MID=@MID AND MSign
on MID=Materials.MID AND Materials.MID=@MID AND MSign