n[gender]=0then'男'else'女'end)性别

    ，(casewhen[auth]=1then'成员'when[auth]=4then'群主'when[auth]=2then'管理'end)身份

    ，[mastqq]

    ，[createdate]

    ，[title]

    ，[class]

    ，[quntext]

    from[groupdata].[dbo].[group]a

    leftjoin[quninfo].[dbo].[qunlist]b

    ona.[qunnum]=b.qunnum

    wherea.[qunnum]=873445991orderby[auth]desc
 <本章"完"请点击"下一章"继续观看!>