sql无法系结多重一部分(Multi-Part)

2014-01-17

sql无法系结多重部分(Multi-Part)查询的条件要ADVirtualStore.material_no material.material_no and ad

sql无法系结多重部分(Multi-Part)

查询的条件要ADVirtualStore.material_no = material.material_no and advirtualstore.material_no = '盖板'，请问各位，我要怎样解决呢？

[解决办法]
估计你的系统是大小写区分的

SELECT  ADVirtualStore.ID ,
        ADVirtualStore.material_no ,
        ADVirtualStore.LineNum ,
        material.title ,
        material.tegory ,
        material.standard ,
        material.material ,
        ADVirtualStore.ListAmount ,
        ADVirtualStore.StoreAmount ,
        ADVirtualStore.QualityInNum ,
        ADVirtualStore.MaterialReNum ,
        ADVirtualStore.PurAmount ,
        material.c_unit ,
        ADVirtualStore.in_mene ,
        ADVirtualStore.in_date ,
        ADVirtualStore.mdf_mene ,
        ADVirtualStore.mdf_date ,
        ADVirtualStore.ExtRequisition ,
        ADVirtualStore.ExtQuality
FROM    ADVirtualStore ,
        material
WHERE   ADVirtualStore.material_no = material.material_no
        AND ADVirtualStore.material_no= '盖板'