SELECT 0 for multiple rows of join
===

I have an invoices and a payments table.  For each invoice record (which contains an OriginalInvoiceValue field), there can be multiple payments associated in the payments table.  In a select that joins the two tables, each invoice record is of course repeated for each occurrence of an associated payment record. What I would like though, is to have the OriginalInvoiceValue field returned only once per invoice, and then have it return zero (or NULL) for each additional occurrence of an associated payment record. (Such that if I were to export the data to excel and sum the OriginalInvoiceValue column, I actually get the real total of all invoices, instead of getting it multiplied by each additional occurrence of a payment).  Is this possible in T-SQL?