|
Вот запрос к базе:
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
|