sql无法系结多重部分(Multi-Part)解决方案

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

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 = '盖板'

查询的条件要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= '盖板'