SELECT DISTINCT a.Id, a.Nom, a.Prenom, CASE WHEN c.Id IS NULL THEN 0 ELSE 1 END as PossedeCle FROM dbo.Abonne a LEFT JOIN dbo.Cle c ON a.id = c.IdAbonne
SELECT DISTINCT
a.Id,
a.Nom,
a.Prenom,
CASE WHEN c.Id IS NULL THEN 0 ELSE 1 END as PossedeCle
FROM dbo.Abonne a
LEFT JOIN dbo.Cle c ON a.id = c.IdAbonne
SELECT DISTINCT a.Id, a.Nom, a.Prenom, CASE WHEN c.Id IS NULL THEN 0 ELSE 1 END as PossedeCle FROM dbo.Abonne a LEFT JOIN dbo.Cle c ON a.id = c.IdAbonne
SELECT DISTINCT a.Id, a.Nom, a.Prenom, CASE WHEN c.Id IS NULL THEN 0 ELSE 1 END as PossedeCle FROM dbo.Abonne a LEFT JOIN dbo.Cle c ON a.id = c.IdAbonne
SELECT DISTINCT
a.Id,
a.Nom,
a.Prenom,
CASE WHEN c.Id IS NULL THEN 0 ELSE 1 END as PossedeCle
FROM dbo.Abonne a
LEFT JOIN dbo.Cle c ON a.id = c.IdAbonne
SELECT DISTINCT a.Id, a.Nom, a.Prenom, CASE WHEN c.Id IS NULL THEN 0 ELSE 1 END as PossedeCle FROM dbo.Abonne a LEFT JOIN dbo.Cle c ON a.id = c.IdAbonne