SQL Query to get Alternatives Items from SAP Business one

Following SQL query use to get  details of alternatives items in SAP Business one.

SELECT T0."OrigItem" as "Original Item", T1."ItemName", T3."ItmsGrpNam", t5."FirmName" as "Manufacturer" ,
 T0."AltItem" as "Alternate Item", T2."ItemName", T4."ItmsGrpNam", t6."FirmName" as "Manufacturer" ,
 T0."Remarks" 
FROM OALI T0 INNER JOIN OITM T1 ON T0."OrigItem" = T1."ItemCode"
 INNER JOIN OITM T2 ON T0."AltItem" = T2."ItemCode" 
INNER JOIN OITB T3 ON T1."ItmsGrpCod" = T3."ItmsGrpCod" 
INNER JOIN OITB T4 ON T2."ItmsGrpCod" = T4."ItmsGrpCod" I
NNER JOIN OMRC T5 ON T1."FirmCode" = T5."FirmCode"

INNER JOIN OMRC T6 ON T2."FirmCode" = T6."FirmCode"