Re: [Emerald] payment / invoice associations

Josh Hillman ( (no email) )
Wed, 16 Jun 1999 12:21:29 -0400

From: Dale E. Reed Jr. <>
>Not sure why you bring the tables in twice. This should work:

That makes two of us. I think I was still in some kind of weird complicated
SQL mode from rewriting a bunch of my stuff lastnight and I didn't bother to
think simplistically this morning. Figures... I'm surprised I missed
something so trivial.

Oh, I also noticed that Charges.Tax is null for all entries (we don't use
tax, so it's not a big deal)--should these be updated to 0.00 instead (as
was necessary with Invoices)?


>Update ii
>Set ii.Quantity = 1
>From InvoiceItems ii, Charges c
>Where c.ItemID = ii.ItemID
> and ii.Quantity > 1