34,590
社区成员
发帖
与我相关
我的任务
分享
select x.INFO_ID,x.USER_ID, zp.LETTER_NAME
from INFO x
left outer join LETTER z on x.LETTER_ID = z.LETTER_ID
left outer join LETTER zp on z.LETTER_PARENT=zp.LETTER_ID
select x.INFO_ID,x.USER_ID, zp.LETTER_NAME
from INFO x
inner join LETTER z on x.LETTER_ID = z.LETTER_ID
left outer join LETTER zp on z.LETTER_PARENT=zp.LETTER_ID
select a.LETTER_NAME from 证书表 a , 信息表 b where a.LETTER_PARENT = 0 and a.LETTER_ID = b.LETTER_ID