tblUser

UserID

Name

...

other basic user info

...

ynDelete

tblUserTests

UserTestID

UserID

TestID

tblTest

TestID

TestName

ynDelete

also, I've gotten this far with my query...I don't think it's right, but I'm getting closer

SELECT T.TestID,

T.TestName,

CASE WHEN UT.UserID = @user-id THEN 1 ELSE 0...