Sam,
Great! I had no idea DISTINCT ON existed. That made it much simpler.
Here's what I used:
select distinct on (inventory.charge) coil_id, inventory.charge,
heating_coldspot_time_reached
from inventory
inner join charge on charge.charge = inventory.charge
where base_type = '3' and heating_coldspot_time_reached > 0 and
inventory.status = 'Done' and inventory.charge >= 1000
order by charge, heating_coldspot_time_reached desc
And thanks for the tip about E-mail. I thought that if I hit the Reply
button and then changed the subject line, it would be the same as
sending a new message to the same destination. In this case, I had to
change the destination also, so it looked like a brand new message. I
didn't know I was bringing along old baggage behind the scenes.
Thanks very much!
RobR