mysql
CREATE VIEW `ths_personbasicInfo_codevalue` AS
SELECT
*,
(SELECT CodeName FROM ths_codevalue WHERE CodeTableID = 'Sex' AND CodeID = ths_nt_personbasiclnfo.PB_XB LIMIT 1) AS sex,
(SELECT CodeName FROM ths_codevalue WHERE CodeTableID = 'CodeTable_MZ' AND C
原创
2021-02-26 03:58:45 ·
194 阅读 ·
0 评论