Inside of "?" if I want to add like below, is it possible? Please show me how.
SELECT COUNT(Receipt_Detail.Receipt_Number) AS totalcountreceipt, SUM(Receipt_Detail.Amount_Applied) AS receiptamount, Invoice_Header.Invoice_Number,? FROM Invoice_Detail INNER JOIN Invoice_Header ON Invoice_Detail.Invoice_Number = Invoice_Header.Invoice_Number INNER JOIN Member_Association ON Invoice_Header.Member_Number = Member_Association.Member_Number INNER JOIN Member ON Invoice_Header.Member_Number = Member.Member_Number INNER JOIN Receipt_Detail ON Invoice_Detail.Invoice_Number = Receipt_Detail.Invoice_Number INNER JOIN Receipt_Header ON Member_Association.Member_Number = Receipt_Header.Member_Number AND Receipt_Detail.Receipt_Number = Receipt_Header.Receipt_Number WHERE (Invoice_Detail.Charge_Code = 'D' OR Invoice_Detail.Charge_Code = 'T' OR Invoice_Detail.Charge_Code = 'N') (Invoice_Header.Invoice_Date BETWEEN '20181201' AND '20190131') AND (Receipt_Header.Deposit_Date BETWEEN '20181201' AND '20190131') and (Invoice_Header.Invoice_Amount > 0) GROUP BY Invoice_Header.Invoice_Number ORDER BY totalcountreceipt DESC
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>