One voucher paying several vendors and invoices is quite normal. The problem is that you have 2 tables, one defines a relationship between voucher, vendor and invoice and the other...

Luis, in our environment we may have 1 voucher that pays several vendors and several invoices among those vendors. The reason this all started is I wanted to concatenate...

OK, missed that sir, I will do what I can to get it asap. I REALLY DO appreciate your help, may not sound like it, but I do. ...

OK, scolding received, apologies to Lynn for not understanding well enough to give you what you need - I still do not think I do, but Luis stepped in so...

David,

That looks closer than what I had gotten so far, Lynn has been very helpful - but I think I am misunderstanding what Lynn is asking for. The only...

Slow your role Lynn, I thought I was giving you what you asked for, OK? Remember, I am new here, I have less experience than you obviously, I am...

Providing us with the DDL (CREATE TABLE statements) and the sample data (INSERT INTO statements) is for us to be able to assist you in working your problem and providing...

Lynn and David,...

Lynn that is very close to what I am looking for, but here is what it gave me (when applied to the tables as they already exist (the vendor is...

First, let me thank all for attempting to help. I am still new to the forums so I have asked the question incorrectly. Let me try to ask...

David Burrows (12/5/2014)

SELECTv.Vchvendor, SUM(vgl.vglamount) AS [VGLamount],

STUFF((SELECT ','+ b.vchinvoicenbr

FROMVoucherGLDist a

JOIN Voucher b ON b.VchVoucherNbr = a.VGLVoucher

WHERE b.VchVendor = v.Vchvendor

FOR XML PATH ('')),1,1,'') AS [Invoices]

FROMVoucherGLDist vgl

JOIN Voucher v ON v.VchVoucherNbr...

Anyone? Anyone?

I actually did not put any of the clauses in there. Here is what the series ACTUALLY looks like (I obviously left some of the table declarations out of...

Jeff, I actually tried that without knowing the term, but there is nothing in common data wise between these tables, which is lousy. I think I just have to...

Steve, apologies about my terminology - still learning and realizing it makes a huge difference. I think you hit the crux. i just don't think there is any...