یک کوئری search

[محمد سلیم آبادی]

کدی شبیه به این:

SELECT quistion FROM questions WHERE question LIKE '%'+@param+'%'

UNION ALL

SELECT question FROM answers  a INNER JOIN questions q ON a.questionid = q.id WHERE answer LIKE '%' + @param + '%'

یا خیلی ساده تر:

SELECT question 

FROM questions q 

INNER JOIN answers a

ON q.id = a.questionid

WHERE q.question LIKE '%'+@param='@' 

OR a.answer LIKE '%'+@param+'%';