SQL拉出空行 [英] SQL Pulling out Blank Row

问题描述

我正在运行的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拉出空行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！