我想从两个表中得到用椭圆画的6列，通过棕色的列互相关联
我写的如下：
select Material_Info.Material_Id，Material_Name,Supplier_Specification,Material_Specification,Plan_Buy_Number,unit,MaPrice
from Material_info,Material_Buy where Material_Info.Material_Id=Material_Buy_BasicInfo.Material_Id and Material_Buy_BasicInfo.Material_Buyorderid=Material_Buy.Material_Buyorderid
但是出错？我只是用过简单的单表查询，对多表查询不熟，请各位帮忙，谢谢！

[此贴子已经被作者于2005-12-11 14:32:31编辑过]