این چطور؟
SELECT DISTINCT q.question
FROM questions q
LEFT OUTER JOIN answers a
ON q.id = a.questionid
WHERE q.question LIKE '%'+@param='@'
OR a.answer LIKE '%'+@param+'%';
این چطور؟
SELECT DISTINCT q.question
FROM questions q
LEFT OUTER JOIN answers a
ON q.id = a.questionid
WHERE q.question LIKE '%'+@param='@'
OR a.answer LIKE '%'+@param+'%';
وبلاگ من (Advanced SQL Querying)