当前位置: 代码迷 >> Sql Server >> sql无法系结多重一部分(Multi-Part)
  详细解决方案

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

热度:233   发布时间:2016-04-24 19:17:45.0
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= '盖板'
  相关解决方案