SQL查询以过滤多个条件

发布于 2025-01-19 19:47:09 字数 1010 浏览 3 评论 0原文

＃我想为model_no添加过滤器，以便如果。我定义了一堆型号（例如（FASD，WQEQWE），它只能在表中填充这些模型。帮助我构建此查询＃

SELECT  
E.T2580_GIN_ID AS GTIN_ID,    
E.T1989_CRY_CD AS CountryCode,    
E.T4478_SEL_ATR_NBR AS Attribute_NO,    
C.T616_VBU_NBR AS VBU_Number,    
B.MOD_IDF_TXT AS MODEL_NO,    
C.T024_ITM_NBR AS Item_No,    
J.T2591_BAR_CD_ID AS Barcode,    
E.ATR_VAL_CHR_TXT AS LPD        
FROM TABLE.T4484_GIN_ATR_LAG  E    
JOIN TABLE.T2594_GIN_VBU_ITM C     
ON (C.T2580_GIN_ID = E.T2580_GIN_ID)    
JOIN TABLE.T2580_GIN_VBU B    
ON (E.T2580_GIN_ID = B.T2580_GIN_ID)    
JOIN TABLE.T2591_GIN_BAR_CD J    
ON (E.T2580_GIN_ID = J.T2580_GIN_ID)    
WHERE E.T1989_CRY_CD IN (1,5)    
AND E.T4478_SEL_ATR_NBR = 3208    
(    
SELECT B.MOD_IDF_TXT    
FROM LOWES.T2580_GIN_VBU B     
WHERE B.MOD_IDF_TXT = 'PA091M35'    
)    
;

原文

#I want to add a filter for model_no such that if. I define a bunch of models, for example(fasd, wqeqwe) it should only populate those in the table. Help me build this query#

SELECT  
E.T2580_GIN_ID AS GTIN_ID,    
E.T1989_CRY_CD AS CountryCode,    
E.T4478_SEL_ATR_NBR AS Attribute_NO,    
C.T616_VBU_NBR AS VBU_Number,    
B.MOD_IDF_TXT AS MODEL_NO,    
C.T024_ITM_NBR AS Item_No,    
J.T2591_BAR_CD_ID AS Barcode,    
E.ATR_VAL_CHR_TXT AS LPD        
FROM TABLE.T4484_GIN_ATR_LAG  E    
JOIN TABLE.T2594_GIN_VBU_ITM C     
ON (C.T2580_GIN_ID = E.T2580_GIN_ID)    
JOIN TABLE.T2580_GIN_VBU B    
ON (E.T2580_GIN_ID = B.T2580_GIN_ID)    
JOIN TABLE.T2591_GIN_BAR_CD J    
ON (E.T2580_GIN_ID = J.T2580_GIN_ID)    
WHERE E.T1989_CRY_CD IN (1,5)    
AND E.T4478_SEL_ATR_NBR = 3208    
(    
SELECT B.MOD_IDF_TXT    
FROM LOWES.T2580_GIN_VBU B     
WHERE B.MOD_IDF_TXT = 'PA091M35'    
)    
;

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

星星的轨迹 2025-01-26 19:47:09

使用double和


SELECT      
E.T2580_GIN_ID AS GTIN_ID,    
E.T1989_CRY_CD AS Country_Code,    
E.T4478_SEL_ATR_NBR AS Attribute_NO,    
C.T616_VBU_NBR AS VBU_Number,    
B.MOD_IDF_TXT AS MODEL_NO ,    
C.T024_ITM_NBR AS Item_No,    
J.T2591_BAR_CD_ID AS Barcode,    
E.ATR_VAL_CHR_TXT AS LPD    
FROM TAble.T4484_GIN_ATR_LAG  E    
JOIN table.T2594_GIN_VBU_ITM C     
ON (C.T2580_GIN_ID = E.T2580_GIN_ID)    
JOIN table.T2580_GIN_VBU B    
ON (E.T2580_GIN_ID = B.T2580_GIN_ID)    
JOIN table.T2591_GIN_BAR_CD J    
ON (E.T2580_GIN_ID = J.T2580_GIN_ID)    
WHERE E.T1989_CRY_CD IN (1,5)    
AND E.T4478_SEL_ATR_NBR = 3208    
AND B.MOD_IDF_TXT IN  ('PA091M35','10019')

Got the answer using Double AND


SELECT      
E.T2580_GIN_ID AS GTIN_ID,    
E.T1989_CRY_CD AS Country_Code,    
E.T4478_SEL_ATR_NBR AS Attribute_NO,    
C.T616_VBU_NBR AS VBU_Number,    
B.MOD_IDF_TXT AS MODEL_NO ,    
C.T024_ITM_NBR AS Item_No,    
J.T2591_BAR_CD_ID AS Barcode,    
E.ATR_VAL_CHR_TXT AS LPD    
FROM TAble.T4484_GIN_ATR_LAG  E    
JOIN table.T2594_GIN_VBU_ITM C     
ON (C.T2580_GIN_ID = E.T2580_GIN_ID)    
JOIN table.T2580_GIN_VBU B    
ON (E.T2580_GIN_ID = B.T2580_GIN_ID)    
JOIN table.T2591_GIN_BAR_CD J    
ON (E.T2580_GIN_ID = J.T2580_GIN_ID)    
WHERE E.T1989_CRY_CD IN (1,5)    
AND E.T4478_SEL_ATR_NBR = 3208    
AND B.MOD_IDF_TXT IN  ('PA091M35','10019')

回复收藏 0 原文

~没有更多了~