I want to be able to run another query using the same fields but to find all places where U_IIS_EXT text is not null and then output the data underneath the current set of data. There would be no data in T0.U_IIS_DDATE or SLPNAME but it would fill data in U_IIS_INADR , T0.Dscription and U_IIS_EXT
SELECT T2.U_IIS_INADR, T0.[Dscription], T0.U_iis_ddate, T1.[SlpName], T0.U_IIS_EXT as Work_Requiring_attention FROM DLN1 T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode INNER JOIN ODLN T2 ON T0.DocEntry = T2.DocEntry left outer join OSCN T3 on t3.ItemCode = t0.ItemCode and t3.Cardcode = SUBSTRING(t2.CardCode, 1, 8) WHERE T2.[U_IIS_JTYPE] = '6' and T0.[U_iis_ddate] = '[%0]' and T2.[CardName] = '[%1]'