Re: Views with Where Clauses

My apologies...
I had a Limit in the view.  So, the second where never got to a valid
record.

Thanks anyway
A

Richard Huxton wrote:

>On Friday 05 September 2003 10:39, Alex wrote:
>
>
>>Hi,
>>I have a view that has some wher clause in it.
>>
>>If I call the view with SELECT * FROM viewx WHERE xxxx ;   (joining 2
>>tables)
>>then I dont get any results back although issuing the command in full
>>i.e. without view i get rows back.
>>
>>Is it not possible to use view that way ?
>>
>>
>
>That's how they're supposed to work. Are you sure there's not some subtle
>mistake in the view definition? Feel free to post it along with the query.
>
>
>