В отчете Сумма Если.... (нужна подсказка)

[a33ik]

Цитата:

Сообщение от KKNDSTER

Вот запрос к базе:

SELECT CRMAF_New_paymentorder.new_paymentdata, CRMAF_New_paymentorder.new_originalcodecostname,
CRMAF_New_paymentorder.new_originaltypecostsname, FilteredIncident.new_artificialname, FilteredIncident.new_suppliername,
CRMAF_New_paymentorder.new_platejnoe_poruchenie, FilteredIncident.incidentid, CRMAF_New_paymentorder.new_platejnoe_porucheniename,
FilteredIncident.new_officename, FilteredIncident.customeridname, FilteredIncident.new_invoicedate, FilteredIncident.transactioncurrencyidname,
FilteredIncident.new_paymentamount, CRMAF_New_paymentorder.new_paymentsumma,
CRMAF_New_paymentorder.transactioncurrencyidname AS Expr1, FilteredIncident.new_invoiceamount,
CRMAF_New_paymentorder.new_originalcodecost, CRMAF_New_paymentorder.new_originaltypecosts
FROM FilteredNew_paymentorder AS CRMAF_New_paymentorder INNER JOIN
FilteredIncident ON CRMAF_New_paymentorder.new_platejnoe_poruchenie = FilteredIncident.incidentid

А зачем столько полей в запросе, если в результате получится - 3-4?