Advertisement
Guest User

Untitled

a guest
Apr 27th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. مینا سعادتجو محیا:
  2. SELECT distinct 1, 0,concat( left(Code,4),'1',substring(code,5,3)), concat('1',substring(code,8,3),'00'), NoeGavahi , shemareh, Tarikh , TarikhEtmam, '', '', '' ,code,0,''
  3. from convert960123.GovGavahi
  4. where concat(1, 0, concat(left(Code,4),'1',substring(code,5,3)),concat('1',substring(code,8,3),'00')) in
  5. (select concat(1, 0, concat(left(Code,4),'1',substring(code,5,3)),concat('1',substring(code,8,3),'00')) from main_bank_960120.arseh) and convert960123.GovGavahi.code='0404048001'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement