1 2 3 4 5 6 7 8 9 10 11
| SELECT DISTINCT
IIF([pcc direct].pc_c>[pcc direct_1].pc_c,[pcc direct].pc_c,[pcc direct_1].pc_c) AS pcc1,
IIF([pcc direct].pc_c>[pcc direct_1].pc_c,[pcc direct1].pc_c,[pcc direct].pc_c) AS pcc2,
31 AS ranking
FROM [pcc direct], [pcc direct] AS [pcc direct_1]
WHERE ( [pcc direct].pc_c <> [pcc direct_1].pc_c and
[pcc direct_1].pc_apl_nat_c = [pcc direct].pc_apl_nat_c
and [pcc direct_1].pc_rs = [pcc direct].pc_rs
and [pcc direct_1].adr_rue = [pcc direct].adr_rue
and [pcc direct_1].adr_ptt_c = [pcc direct].adr_ptt_c
and [pcc direct_1].adr_bur_dis= [pcc direct].adr_bur_dis |
Partager