|
| Fax to:
|
| Subject: Unexpected behaviour: SELECT with OR returns empty set
|
>---
I am not sure what you are trying to do.
Do you want a join, or a union.
Your query is neither, and the results are correct as written.
Dave Gibson wrote:
Hi,
I'm getting some unexpected behaviour from a query and was
hoping someone could shed some light on whether it's a user
error or something el
Hi,
I'm getting some unexpected behaviour from a query and was
hoping someone could shed some light on whether it's a user
error or something else.
I have two tables:
customers, oems which both have a companyID field (marked
as a foreign key).
When I do:
SELECT * FROM customers WHERE customers.c
