Create Cursor test (id_card i, spec c( 20 ), val_text c( 30 ))
Insert into test values( 1251 , "stCode", "ÃÎÑÒ 2590-88")
Insert into test values( 1251 , "stStatusNd", "Çàìåíåí")
Insert into test values( 1255 , "stCode", "ÃÎÑÒ 11017-80")
Insert into test values( 1255 , "stStatusNd", "Äåéñòâóåò")

Select t1.id_card, t1.val_text, t2.val_text ;
from test  as t1 ;
inner join test as t2 on t1.spec="stCode" and t2.spec="stStatusNd" and t1.id_card = t2.id_card