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