as 查询问题

select *,(select nick from cy_member where id=uno) as uno_name,(select name from cy_works_kind where id=kind_id) as kind_id_name from cy_works where 1=1 order by id desc limit 0,10 

我想判断uno_name 这个字段，提示出错
这个表是会员和积分表
该怎么使用条件

SQL code

select *,(select nick from cy_member where id=A.uno) as uno_name,(select name from cy_works_kind where id=A.kind_id) as kind_id_name 
from cy_works A
where 1=1 
order by id desc limit 0,10