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