اینو امتحان کردین؟
SELECT question
FROM questions
INNER JOIN dbo.fnParseList(' ', @param) AS f
ON question LIKE '%' + f.Data + '%'
GROUP BY question
HAVING COUNT(*) = (SELECT COUNT(*) FROM dbo.fnParseList(' ', @param))
UNION
SELECT question
FROM questions q
JOIN answers a
ON q.id = a.questionid
JOIN
(
SELECT a.answer
FROM answers a
INNER JOIN dbo.fnParseList(' ', @param) AS f
ON answer LIKE '%' + f.Data + '%'
GROUP BY answer
HAVING COUNT(*) = (SELECT COUNT(*) FROM dbo.fnParseList(' ', @param))
) D ON a.question = D.question;
