select A.MUSADI,A.BAACIKLA,A.ACIKLAMA,B.eFaturaDurumu,B.eFaturaNo from ACARI A , STOKHARDETBAG B WHERE A.ISLEMNO=B.IslemNo AND A.BAACIKLA=B.IslemTuru
AND B.eFaturaNo LIKE 'B%' 
 ORDER BY A.ISLEMNO DESC 



 update A       
   set A.ACIKLAMA   =B.eFaturaNo+'  no.lu Fatura' 
 from  ACARI A,STOKHARDETBAG B       
 where  A.ISLEMNO=B.IslemNo AND A.BAACIKLA=B.IslemTuru
AND B.eFaturaNo LIKE 'B%' 
AND A.BAACIKLA IN ( 'Alış İade','Satış')