TABLE Students (
    <SOME KEY> -- Could be a surrogate Identity or similar but it has to be unique
    , [name] -- Student Name
    )

TABLE Courses (
    <SOME KEY> -- Again if there is no good unique candidate then a surrogate key could be used
    , [name] -- Course Name
    )

TABLE classAssignment (
    <SOME KEY> -- this could be a compound key over the following two columns or a surrogate key
    , [student_ID] FOREIGN KEY to <PRIMARY_KEY> on students table
    , [course_ID] FOREIGN KEY to <PRIMARY_KEY> on courses table
    )

SELECT
    s.[name]
    , CASE
       WHEN c.[course] IS NULL THEN 0
       ELSE 1
   END AS [Student of SAXO]
FROM
    students s
    LEFT JOIN courses c ON
         c.[name] = s.[name]
         AND c.[course] = 'saxo'

quote:

---

Originally posted by waterduck

DECLARE @students TABLE(name varchar(20))
INSERT INTO @students
SELECT 'jose' UNION ALL
SELECT 'william' UNION ALL
SELECT 'john' UNION ALL
SELECT 'sandra' 

DECLARE @courses TABLE(name varchar(20), course varchar(20))
INSERT INTO @courses
SELECT 'jose', 'saxo' UNION ALL
SELECT 'william', 'cook' UNION ALL
SELECT 'john', 'saxo' UNION ALL
SELECT 'sandra', 'garden'

SELECT	s.name, CASE WHEN course = 'saxo' then 1 else 0 END
FROM	@students s join @courses c on s.name=c.name

---

Hope can help...but advise to wait pros with confirmation...

---