tryselect ID , (select SX_MESSAGE from B where 表C_ID ='1' and DM = A.SEX) as SEX , (select SX_MESSAGE from B where 表C_ID ='2' and DM = A.NATURE) as NATURE , NAME from A
SELECT a.ID, (CASE sex when 100 THEN '男' ELSE '女' end) AS Sex,b.SEX_message,a.Name FROM table_a a, table_b b WHERE a.nature = b.dm
SELECT a.ID, a.性别,b.民族, a.姓名 FROM a INNER JOIN b ON a.ID = b.ID
常用join合并两个数据库.
我给你表的例子
表A
ID SEX NATURE NAME
1 100 50 张三
2 100 51 李四
3 101 55 王丽
表B
ID 表C_ID SX_MESSAGE DM
1 1 男 100
2 1 女 101
3 2 汉 50
4 2 回 51
5 2 满 55
表C
ID ENG_NAME CHS_NAME
1 SEX 性别
2 NATURE 民族
这三个表有一定的内在联系。
最后:我要的结果是:
1 男 汉 张三
2 男 回 李四
3 女 满 王丽
, (select SX_MESSAGE from B where 表C_ID ='1' and DM = A.SEX) as SEX
, (select SX_MESSAGE from B where 表C_ID ='2' and DM = A.NATURE) as NATURE
, NAME
from A
SELECT a.ID, (CASE sex when 100 THEN '男' ELSE '女' end) AS Sex,b.SEX_message,a.Name
FROM table_a a, table_b b
WHERE a.nature = b.dm