Innerjoin sin id
Publicado por Wichi (6 intervenciones) el 25/07/2019 21:29:18
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
select CCU_OFICI,CCUNUMCUE,CCUDIGVER,CNO_CUENT,
(CASE WHENRIGHT((RIGHT(('00'+CAST(CFEULTTRA AS VARCHAR(6))),6)),2)<57 THEN '20' ELSE '19' END)
+RIGHT((RIGHT(('00'+CAST(CFEULTTRA AS VARCHAR(6))),6)),2)
+'/'+SUBSTRING((RIGHT(('00'+CAST(CFEULTTRA AS VARCHAR(6))),6)),3,2)
+'/'+
LEFT((RIGHT(('00'+CAST(CFEULTTRA AS VARCHAR(6))),6)),2)
FECHAULTIMATRAN, CSATOTHOY, CCOESTCUE, P.ANO_PRODU from ACMCC A
INNER JOIN AAMPR P ON A.CCU_PRODU=P.ACO_PRODU
WHERE (CASE WHENRIGHT((RIGHT(('00'+CAST(CFEULTTRA AS VARCHAR(6))),6)),2)<20 THEN '20' ELSE '19' END)
+RIGHT((RIGHT(('00'+CAST(CFEULTTRA AS VARCHAR(6))),6)),2)
+'/'+SUBSTRING((RIGHT(('00'+CAST(CFEULTTRA AS VARCHAR(6))),6)),3,2)
+'/'+
LEFT((RIGHT(('00'+CAST(CFEULTTRA AS VARCHAR(6))),6)),2) < '2018/03/18' AND CCOESTCUE=2 AND A.ESTADO='A' AND P.ESTADO='A'
Valora esta pregunta
-1