, Guest>> || || |
/ Oracle
  ,   [new]
Stoun
Member

:
: 8
, !

(((

:

DOC
+-----------+-----------------+--------------+
DOC_IDNOMTEXT
+-----------+-----------------+--------------+
1010117/001
2010117/002
3030117/003
4080117/004
5230117/005


OPIS
+---------------+-----------------+-------------------------------+
P_DOC_IDKODNAME
+---------------+-----------------+-------------------------------+
11024 54/7
13017
14056 46
15018 /
24056 37
31024 /
34056 58
44056 36
55018

DOC_ID P_DOC_ID.
DOC , OPIS KOD=1024.

.. : 010117/002, 080117/004, 230117/005.
, .
010117/001 030117/003 , KOD=1024.

, .
!
16 17, 13:38[20217617]      |
 Re: ,   [new]
--Eugene--
Member

:
: 1973
Stoun,

select * from doc d where not exists(select 1 from opis o where o.p_doc_id = d.doc_id)
16 17, 13:49[20217671]      |
 Re: ,   [new]
--Eugene--
Member

:
: 1973
--Eugene--,

!

select * from doc d where not exists(select 1 from opis o where o.kod = 1024 and o.p_doc_id = d.doc_id)
16 17, 13:51[20217677]      |
 Re: ,   [new]
Stoun
Member

:
: 8
--Eugene--,

, , !
17 17, 09:53[20220129]      |
/ Oracle