Re: Views with Where Clauses

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.

--
  Richard Huxton
  Archonet Ltd