7 lines
262 B
SQL
7 lines
262 B
SQL
|
|
SELECT UNIQUE a.cod_sp,a.cod_sp_sec,b.nom_sp
|
|
FROM cptb00001 a,cotb00001 b
|
|
WHERE a.cod_sp_sec = a.cod_sp_sec AND a.cod_sp = b.cod_sp AND
|
|
a.cod_sp_sec=b.cod_sp_sec AND a.status_t is null AND a.cod_sp = 23
|
|
ORDER BY 1,2
|