枚举值的查询

select

(select FNAME from T_META_FORMENUM_L where FID = T_META_FORMENUMITEM.FID and FLOCALEID =  2052) '枚举类型名称'

,(select FCAPTION from T_META_FORMENUMITEM_L where FENUMID = T_META_FORMENUMITEM.FENUMID  and FLOCALEID = 2052) '枚举项名称'

,*

from T_META_FORMENUMITEM order by FID,FSEQ

你怎么打发时间，时间怎么打发你！

--查某一项枚举值

select mj.FID,mjL.FNAME MJNAME, mjitem.FENUMID FENUMID,mjitemL.FCAPTION

from T_META_FORMENUM mj(nolock)

 inner join T_META_FORMENUM_L mjL(nolock) on mj.FID=mjL.FID and mjL.FLOCALEID=2052

 inner join T_META_FORMENUMITEM mjitem(nolock) on mj.FID=mjitem.FID

 inner join  T_META_FORMENUMITEM_L mjitemL(nolock)  on mjitem.FENUMID=mjitemL.FENUMID and mjitemL.FLOCALEID=2052

 where mjL.FNAME='采购价目表价格类型'