HELP IN THIS QUERY (ITEM PROPERTY SALES ANALYSIS)

HELLO EXPERTS,

IN THE BELOW QUERY I HAVE SOME PROBLEM LIKE IN MY ITEM MASTER I HAVE SELECT TWO ITEM PROPERTY IN IT. BUT IN THIS QUERY ITS NOT SHOWING THE SECOND ITEM PROPERTY.

PLEASE RESOLVE THIS.

Select T0.[DocNum],
T0.[DocDate],
Case when T0.[ObjType] = 13 then 'INVOICE' when T0.[ObjType] = 14 then 'CREDIT NOTE' end as 'Type',
T0.[CardCode],
T0.[CardName],
T1.[ItemCode],
T1.[Dscription],
T1.[Quantity],
T1.[LineTotal] as 'Total Sale',
Case when T1.[Rate] = 0 then T1.[LineTotal] else (T1.[LineTotal]/T1.[Rate]) end as 'Equivalent Value',
Case when (T1.[Quantity] = 0 and (T1.[StockPrice]*T1.[Quantity])= 0 ) then T1.[LineTotal] else (T1.[INMPrice]*T1.[Quantity]) end as 'Sales - Net',
(T1.[StockPrice]*T1.[Quantity]) as 'Cost',
T1.[GrssProfit],
Case when (T1.[INMPrice]*T1.[Quantity]) =0 then 0 else (T1.[GrssProfit]/(T1.[INMPrice]*T1.[Quantity]))*100 end as 'GP %age'
, T3.ItmsGrpNam
FROM OINV T0
INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry]
INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode
LEFT JOIN OITG T3 ON CASE WHEN ISNULL(T2.QryGroup1, '') = 'Y' THEN 1 WHEN ISNULL(T2.QryGroup2, '') = 'Y' THEN 2 WHEN ISNULL(T2.QryGroup3, '') = 'Y' THEN 3 WHEN ISNULL(T2.QryGroup4, '') = 'Y' THEN 4 WHEN ISNULL(T2.QryGroup5, '') = 'Y' THEN 5 WHEN ISNULL(T2.QryGroup6, '') = 'Y' THEN 6 WHEN ISNULL(T2.QryGroup7, '') = 'Y' THEN 7 WHEN ISNULL(T2.QryGroup8, '') = 'Y' THEN 8 WHEN ISNULL(T2.QryGroup9, '') = 'Y' THEN 9 WHEN ISNULL(T2.QryGroup10, '') = 'Y' THEN 10 WHEN ISNULL(T2.QryGroup11, '') = 'Y' THEN 11 WHEN ISNULL(T2.QryGroup12, '') = 'Y' THEN 12 WHEN ISNULL(T2.QryGroup13, '') = 'Y' THEN 13 WHEN ISNULL(T2.QryGroup14, '') = 'Y' THEN 14 WHEN ISNULL(T2.QryGroup15, '') = 'Y' THEN 15 WHEN ISNULL(T2.QryGroup16, '') = 'Y' THEN 16 WHEN ISNULL(T2.QryGroup17, '') = 'Y' THEN 17 WHEN ISNULL(T2.QryGroup18, '') = 'Y' THEN 18 WHEN ISNULL(T2.QryGroup19, '') = 'Y' THEN 19 WHEN ISNULL(T2.QryGroup20, '') = 'Y' THEN 20 WHEN ISNULL(T2.QryGroup21, '') = 'Y' THEN 21 WHEN ISNULL(T2.QryGroup22, '') = 'Y' THEN 22 WHEN ISNULL(T2.QryGroup23, '') = 'Y' THEN 23 WHEN ISNULL(T2.QryGroup24, '') = 'Y' THEN 24 WHEN ISNULL(T2.QryGroup25, '') = 'Y' THEN 25 WHEN ISNULL(T2.QryGroup26, '') = 'Y' THEN 26 WHEN ISNULL(T2.QryGroup27, '') = 'Y' THEN 27 WHEN ISNULL(T2.QryGroup28, '') = 'Y' THEN 28 WHEN ISNULL(T2.QryGroup29, '') = 'Y' THEN 29 WHEN ISNULL(T2.QryGroup30, '') = 'Y' THEN 30 WHEN ISNULL(T2.QryGroup31, '') = 'Y' THEN 31 WHEN ISNULL(T2.QryGroup32, '') = 'Y' THEN 32 WHEN ISNULL(T2.QryGroup33, '') = 'Y' THEN 33 WHEN ISNULL(T2.QryGroup34, '') = 'Y' THEN 34 WHEN ISNULL(T2.QryGroup35, '') = 'Y' THEN 35 WHEN ISNULL(T2.QryGroup36, '') = 'Y' THEN 36 WHEN ISNULL(T2.QryGroup37, '') = 'Y' THEN 37 WHEN ISNULL(T2.QryGroup38, '') = 'Y' THEN 38 WHEN ISNULL(T2.QryGroup39, '') = 'Y' THEN 39 WHEN ISNULL(T2.QryGroup40, '') = 'Y' THEN 40 WHEN ISNULL(T2.QryGroup41, '') = 'Y' THEN 41 WHEN ISNULL(T2.QryGroup42, '') = 'Y' THEN 42 WHEN ISNULL(T2.QryGroup43, '') = 'Y' THEN 43 WHEN ISNULL(T2.QryGroup44, '') = 'Y' THEN 44 WHEN ISNULL(T2.QryGroup45, '') = 'Y' THEN 45 WHEN ISNULL(T2.QryGroup46, '') = 'Y' THEN 46 WHEN ISNULL(T2.QryGroup47, '') = 'Y' THEN 47 WHEN ISNULL(T2.QryGroup48, '') = 'Y' THEN 48 WHEN ISNULL(T2.QryGroup49, '') = 'Y' THEN 49 WHEN ISNULL(T2.QryGroup50, '') = 'Y' THEN 50 WHEN ISNULL(T2.QryGroup51, '') = 'Y' THEN 51 WHEN ISNULL(T2.QryGroup52, '') = 'Y' THEN 52 WHEN ISNULL(T2.QryGroup53, '') = 'Y' THEN 53 WHEN ISNULL(T2.QryGroup54, '') = 'Y' THEN 54 WHEN ISNULL(T2.QryGroup55, '') = 'Y' THEN 55 WHEN ISNULL(T2.QryGroup56, '') = 'Y' THEN 56 WHEN ISNULL(T2.QryGroup57, '') = 'Y' THEN 57 WHEN ISNULL(T2.QryGroup58, '') = 'Y' THEN 58 WHEN ISNULL(T2.QryGroup59, '') = 'Y' THEN 59 WHEN ISNULL(T2.QryGroup60, '') = 'Y' THEN 60 END = ItmsTypCod
WHERE
T0.[CANCELED] = 'N' and
T0.[DocDate] >= [%0] and
T0.[DocDate] <=[%1] and
T1.[LineTotal] <> '0'