Based on your datatypes I would have to say that you are using ACCESS rather than SQL Server.
Next, if I understand your schema correctly you are violating 1st Normal Form and that is causing your difficulties.
I would look at normalizing your database design.
In the meantime this might work
SELECT Doc_ID, Doc_Title, 'Test1'
FROM Docs -- or whatever your table is named
WHERE DOC_Id = 'Doc_123'
AND Test1 = 'y' -- or true or whatever is in access
UNION ALL
SELECT Doc_ID, Doc_Title, 'Test2'
FROM Docs -- or whatever your table is named
WHERE DOC_Id = 'Doc_123'
AND Test2 = 'y'
UNION ALL
SELECT Doc_ID, Doc_Title, 'Test3'
FROM Docs -- or whatever your table is named
WHERE DOC_Id = 'Doc_123'
AND Test3 = 'y'
UNION ALL
SELECT Doc_ID, Doc_Title, 'Test4'
FROM Docs -- or whatever your table is named
WHERE DOC_Id = 'Doc_123'
AND Test4 = 'y'
UNION ALL
SELECT Doc_ID, Doc_Title, 'Test5'
FROM Docs -- or whatever your table is named
WHERE DOC_Id = 'Doc_123'
AND Test5 = 'y'
IF You normalize your design then you could do something like this
SELECT d.Doc_ID, DOc_Title, TT.TestTypeDesc
FROM Docs D
JOIN DocTests DT
ON D.Doc_ID = DT.Doc_ID
JOIN TestTypes TT
ON DT.TestTypeID = TT.TestTypeID
WHERE D.Doc_ID = 'Doc_123' -- although you will be better off if you switch that to an integer identity (in access autonumber)
David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
sql statement for asp.net page
