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.Kraaijeveld@Askesis.nl
web: www.askesis.nl