本文介绍了SQL拉出空行的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我正在运行的SQL，似乎是在拉出一个空白行
My SQL that I am running, seems to be pulling out a blank row
Select
T1.cl_ID as ClaimID,
(T11.Full_Desc) as Damage1,
(T12.Full_Desc) as Damage2
FROM
(((cl_details T1)
LEFT OUTER JOIN cl_coding T4 on (T1.cl_id = T4.cl_id))
Left Outer Join Sy_code_list T11 on (t4.ID_Code = t11.ID_Code and t4.Level_2 = t11.Level_2 and t11.ID_Code = 4 and (t11.Level_3 = 0 or t11.Level_3 = -1)))
Left Outer Join Sy_code_list T12 on (t4.ID_Code = t12.ID_Code and t4.Level_2 = t12.Level_2 and t4.Level_3 = t12.Level_3 and t12.ID_Code = 4 and (t12.Level_4 = 0 or t12.Level_4 = -1))
Group By
T1.cl_ID,
(T11.Full_Desc),
(T12.Full_Desc)
我如何才能如此它排除了空白。
How would I make it so that it excluded the blanks.
Tia
推荐答案
只是猜测但尝试使用INNER JOIN而不是LEFT JOIN。
Just a guess but try using an INNER JOIN instead of a LEFT JOIN.
只是一个想法......
Just a thought...
这篇关于SQL拉出空行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！