[SQL] Diffcult query

Hi folks. This is giving me fits. I feel like it oughta be simple, but apparantly its not...I think. Given a table : create table tablea ( code1 varchar(32), code2 varchar(32), costint ); and the rows code1code2cost -- "aaa""bbb"2 "d

[SQL] Seeking help with a query....

Hi folks, seeking help with a query that I thought was simple, but apparantly isn't, at least for someone with my knowledge level. Given a table : create table atable ( code1 char, code2 char, costint ); And the rows code1code2cost - ab