_SQLINFO kullanim

[ROVSHEN]

Merhaba Arkadaslar!

Satinalma Fakturasi icinde 1-malzeme ve bir 1-hizmet kartlarim var.
Cap etdiyim zaman raporda her ikisinin Muhasebe Kodunu gormek istiyorum satir yaninda.
Bunu nasil coze bilirim?

INVOICE-REF(Tanimli alan)---_SQLINFO("ACCOUNTREF","LG_XXX_XX_STLINE","STOCKREF='"+[LOGICALREF]+"'")
LOGICALREF (Tanimli alan)--- _SQLINFO("LOGICALREF","LG_XXX_ITEMS","CODE='"+[Malzeme Kodu]+"'")
MUHASEBE KOD(Tanimli alan)----_SQLINFO("CODE","LG_XXX_EMUHACC","LOGICALREF='"+[INVOICEREF_ST]+"'")

[ROVSHEN]

SELECT I.CODE, S.AMOUNT  FROM LG_777_ITEMS I, LG_777_01_STLINE S
WHERE I.LOGICALREF=S.STOCKREF AND S.LINETYPE=0
UNION ALL
SELECT I.CODE, S.AMOUNT  FROM LG_777_ITEMS I, LG_777_01_STLINE S
WHERE I.LOGICALREF=S.STOCKREF AND S.LINETYPE=4