子查询 如果出现这种情况 怎么办？

[hql5202004]

子查询 如果出现这种情况 怎么办？
先贴上代码：
select * from (select row_number() over(order by userKeywordsID) as Rownum
,userID,title
from 表A where status=1 and statusPlan=1
and (budgetMoneyLimit=0 or budgetMoneyLimit<= (select clickAllMoney from VM_表B
where VM_表B.userID =表A.userID)) group by userKeywordsID,userID,title)a
where (Rownum between 1 and 10)


其中 子查询 budgetMoneyLimit<= (select clickAllMoney from VM_表B
where VM_表B.userID =表A.userID)

而 (select clickAllMoney from VM_表B
where VM_表B.userID =表A.userID) 这语句 有时候查询结果是没有记录的 。导致 budgetMoneyLimit<= 没有记录的？？

这样语句 就查不到东西了？如何改动。。。？

[「已注销」]

TRY~~~
select * from (select row_number() over(order by userKeywordsID) as Rownum
,userID,title
from 表A where status=1 and statusPlan=1
and (budgetMoneyLimit=0 or EXISTS (select NULL from VM_表B
where VM_表B.userID =表A.userID AND 表A.budgetMoneyLimit<= budgetMoneyLimit)) group by userKeywordsID,userID,title)a
where (Rownum between 1 and 10)

[xman_78tom]

budgetMoneyLimit<= isnull((select clickAllMoney from VM_表B
where VM_表B.userID =表A.userID), budgetMoneyLimit)

[-晴天]

budgetMoneyLimit<= (select clickAllMoney from VM_表B where VM_表B.userID =表A.userID)
select * from (select row_number() over(order by userKeywordsID) as Rownum,userID,title  
 from 表A where status=1 and statusPlan=1  
and (budgetMoneyLimit=0 or 
exists(select 1 from  VM_表B where VM_表B.userID =表A.userID and 表A.budgetMoneyLimit<=clickAllMoney))
group by userKeywordsID,userID,title)a where (Rownum between 1 and 10)

[飘零一叶]

select * from (select row_number() over(order by userKeywordsID) as Rownum  
 ,userID,title  
 from 表A where status=1 and statusPlan=1  
and (budgetMoneyLimit=0 or budgetMoneyLimit<= (select clickAllMoney from VM_表B  
where VM_表B.userID =表A.userID and clickAllMoney is not null)) group by userKeywordsID,userID,title)a
 where (Rownum between 1 and 10)