Query, view join question.

Hi all,

I have 2 tables:

table1 with the columns objectid, refobjectid, commonvaluecol and value1.
table2 with the columns objectid, refobjectid, commonvaluecol and value2.

A "select * from table2 where commonvaluecol = 123 and value2 > 0" returns no rows.

I create a view:

create view miracle as
select table1.objectid, table1.value1, table1.commonvalue, table1.refobjectid, table2.value2
from table1 joing table2 on table1.refobjectid = table2.refobjectid
where commonvaluecol = 123

Than I do a "select * from miracle where commonvaluecol = 123 and value2 > 0"

This query returns many rows. (How) Is this possible?

Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl