SQL "OR"

Andrew Sinning andrew at learningware.com
Tue Feb 24 15:38:23 CST 2004


I'm having a tough time understanding why my "OR" doesn't workin the
following query:

SELECT qId FROM questions, answers WHERE stemText LIKE 'what' no_case

-- yeilds 16 results.  This is a expected

-- now, if I add an OR to the WHERE clause, I should expect at least 16
results, correct?


SELECT qId FROM questions, answers  WHERE stemText LIKE 'what' no_case
OR answers.text LIKE 'what' no_case

-- yeilds 0 results




More information about the Valentina mailing list