> However, this query does not give me the result I expected. It appears that
> the database engine first calculates the cartesian product of the tables A
> and B and then evaluates the query. Hence, I get multiple matches for
Yup.. WHERE filters the results of the join.
> Is there any way to do
Hi all,
I have the following problem which I will illustrate with a simplified
example.
I have two tables A and B. Both tables contain three columns named "objid",
"owner", and "val" all of type integer. I want to select all records in A
for which A.val=0 and all records in B for which both B.val
