11 lines
553 B
SQL
11 lines
553 B
SQL
--SELECT * FROM T_META_FORMENUM --枚举主表
|
|
--SELECT * FROM T_META_FORMENUM_L --枚举多语言表
|
|
--SELECT * FROM T_META_FORMENUMITEM --枚举项主表
|
|
--SELECT * FROM T_META_FORMENUMITEM_L --枚举项多语言表
|
|
|
|
SELECT t0.FID,t0_l.FNAME,t0e.FENUMID,t0e.FSEQ,t0e.FVALUE,t0e_l.FCAPTION
|
|
FROM T_META_FORMENUM t0
|
|
INNER JOIN T_META_FORMENUMITEM t0e on t0e.FID = t0.FID
|
|
INNER JOIN T_META_FORMENUM_L t0_l on t0.FID = t0_l.FID AND t0_l.FLOCALEID = 2052
|
|
INNER JOIN T_META_FORMENUMITEM_L t0e_l on t0e.FENUMID = t0e_l.FENUMID AND t0e_l.FLOCALEID = 2052
|
|
ORDER BY t0.FID,t0e.FSEQ |