This is the second time this week that I've used a SQL join like
PMT.PMT_ID = PMTDBT.PMTDBT_ID
but meant to say
PMT.PMT_ID = PMTDBT.PMT_ID
. Both values are of type NUMERIC but I wish Sybase knew that their domains are unrelated and that each were of a distinct type PMT_ID and PMTDBT_ID or similar.
That way it'd just be invalid to compare the two unless I somehow defined a way to convert from one of those types to the other.