JV001 SELECT gm.*, cnt.JpnName as gensankoku, sm.MSCode as smMSCode, sm.SubCode as smSubCode, sm.Appendix as smAppendix, sm.Color as Color, sm.ClothesSize as ClothesSize, sm.ColorCode as ColorCode, sm.ColorCode2 as ColorCode2, sm.DenpSize as DenpSize FROM iruirudb.st_goods_master as gm inner join iruirudb.country as cnt on (gm.PlaceOfOrigin = cnt.Code) inner join iruirudb.st_goods_sub as sm on (gm.MSCode = sm.MSCode and sm.NotProduct=0) where ((((gm.MSGroupParentCode is NULL) or (gm.MSGroupParentCode ="") ) and gm.MSCode = "JV001" ) or (gm.MSGroupParentCode = "JV001") ) and gm.NotProduct=0 order by gm.MSGroupDispNo, sm.Number ASC wk_maxct = 0
