我想从两个表中得到用椭圆画的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编辑过]

select Material_Info.Material_Name,Material_Info.Supplier_Specification,
Material_Info.Material_Specification,Material_Buy.Plan_Buy_Number,
Material_Buy.unit,Material_Buy.MaPrice from Material_info,Material_Buy_basic,material_Buy
where material_info.material_Id=material_buy_basic.material_Id and
material_Buy_basic.material_buyorderid=material_buy.material_buyorderSN
你可以试这段代码，不过里面的大小写我没有太注意，你看看可以吗？我想要是没有什么大小写错误的话，应该是正确的，我也是新手，SQL2000原理是自学的，你还得仔细的看看了。

[QUOTE]select Material_Info.Material_Id，Material_Name,Supplier[/QUOTE]
第一个逗号是中文的