SELECT HDOSYAID,HKIMLIKID,HDTARIH,ICMALID FROM HDOSYA WHERE ICMALID NOT IN (SELECT ICMALID FROM ICMAL)

Elektra
                                                                              Tarih       : [BUGUN   ]
                                                                              Saat        :   [BUSAAT]
                                                                              Alındığı T. : [GTARIH  ]

                    ICMAL DUZELTME RAPORU


  HDOSYAID      HKIMLIKID      HDTARIH      ICMALID     
  ------------- -------------- ------------ ------------
{ [>HDOSYAID:N] [>HKIMLIKID:N] [HDTARIH:D ] [>ICMALID:N]}


>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
UPDATE HDOSYA SET ICMALID=NULL WHERE ICMALID NOT IN (SELECT ICMALID FROM ICMAL)

