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 34 35
| CREATE TABLE TbAdherent
(
IDAdherent INT IDENTITY CONSTRAINT PK_TbAdherent_IDAdherent PRIMARY KEY,
NomAdherent VARCHAR(16),
Tennis BIT CONSTRAINT DF_TbAdherent_Tennis DEFAULT (0),
Ski BIT CONSTRAINT DF_TbAdherent_Ski DEFAULT (0)
)
GO
INSERT INTO dbo.TbAdherent VALUES ('ElSuket', 1, 1)
INSERT INTO dbo.TbAdherent VALUES ('Gringo', 0, 1)
INSERT INTO dbo.TbAdherent VALUES ('Caramba', 0, 1)
INSERT INTO dbo.TbAdherent VALUES ('Toto', 1, 0)
INSERT INTO dbo.TbAdherent VALUES ('Titi', 1, 0)
GO
SELECT NomAdherent
FROM dbo.TbAdherent
WHERE Tennis = 1
AND Ski = 1
SELECT A1.NomAdherent
FROM dbo.TbAdherent A1
JOIN dbo.TbAdherent A2 ON A1.IDAdherent = A2.IDAdherent
WHERE A1.Tennis = 1
AND A2.Ski = 1
SELECT NomAdherent
FROM dbo.TbAdherent
WHERE Tennis = 1
INTERSECT
SELECT NomAdherent
FROM dbo.TbAdherent
WHERE Ski = 1 |
Partager