SELECT *, ABS(dt1.x2-dt2.y2) AS dx ; FROM ( ; select temp1.*,nodes.x as x2, nodes.y as y2, from UPDNETATR!xydata nodes ; right outer join temp1 ; on nodes.n = temp1.b; where st_name <> ' ' ; order by temp1.st_name ; ) dt1>Yes it is:
>select temp1.*,nodes.x as x2, nodes.y as y2, ABS(nodes.x-nodes.y) AS dx; > from UPDNETATR!xydata nodes ; > right outer join temp1 ; > on nodes.n = temp1.b; > where st_name <> ' ' ; > order by temp1.st_name >