1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = '#t1') DROP TABLE #t1;
SELECT
PersID,
count(PersID) as cnt
into #t1
FROM Personnes_tbl
INNER JOIN Link_Contacts_tbl ON PersID = CtacPersID
group by PersID;
SELECT
#t1.PersID AS PersID,
#t1.cnt,
PersNom AS Nom,
PersPrenom AS Prenom,
PersSexID AS Sex,
PaysNomFR AS Nationalite,
PersGSM AS Mobile,
PersTel AS Tel,
PersEmail AS Email
FROM #t1,Personnes_tbl
LEFT OUTER JOIN Pays_tbl ON PersNationID = PaysID
where #t1.PersID=Personnes_tbl.PersID; |
Partager