I hereby claim:
- I am gpeng on github.
- I am gpeng (https://keybase.io/gpeng) on keybase.
- I have a public key ASB_s078QkolN2cwe1JPkgMC0a8onPvfG_cJyiEKcUeVPwo
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
select new_contract.contract_end_date, new_contract.combined_meter_number, previous_contract.new_supplier_estimated_start_date | |
from contract as new_contract | |
left outer join | |
(select new_supplier_contract_estimated_start_date from contract) as previous_contract on | |
previous_contract.combined_meter_number = new_contract.combined_meter_number |