Re: Query, view join question.

You haven't given the complete information but the following is just a guess.

It seems that abonnement is in both tables.

The view is stating

abo_his.abonnement = 238

I assume that your initial query was

WHERE abo_klt.abonnement = 238 and
AND abo_klt.afgewerkt > 2

My guess is that you are asking the view a different question:

WHERE abo_his.abnnement = 238
AND abo_klt.afgewerkt > 2

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>