Re: view calling a view problem
From: Patrick (psully_at_nospam.eatel.net)
Date: 01/26/05
- Next message: Aaron Weiker: "Re: Select from 4 tables with COUNT(*)"
- Previous message: --CELKO--: "Re: "Macro" statement"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 25 Jan 2005 18:47:36 -0600
Thanks, Aaron and David. I decided not to use the 2nd to call the 1st when
it was simpler to just have it do its own thing. Sounds like a good idea not
to chain views together, like I found out too, David.
Regards,
Patrick
"Patrick" <psully@nospam.eatel.net> wrote in message
news:l9-dne-yZNEXJ2jcRVn-sQ@eatel.net...
> Thanks Aaron. Strange that a question like this seems so hard to find the
> answer to in a either BOL or tree based SQL books. Um, how can I rewrite
the
> 1st view and not use it, you mean not use that view? I am about to say
screw
> using a view for a view, at least in this case.
>
>
> "Aaron Weiker" <aaron@sqlprogrammer.org> wrote in message
> news:113340632422014152024494@news.microsoft.com...
> > Hello Patrick,
> > You can only reference columns in a view that are in the SELECT list.
That
> > means that if you need a column from your second view you either have to
> > rewrite the first view and not use it, or you need to include it in you
> first
> > view.
> >
> > --
> > Aaron Weiker
> > http://aaronweiker.com/
> >
> > > I have this view:
> > >
> > > CREATE VIEW CautionDescriptions AS
> > > SELECT TOP 100 PERCENT
> > > Oils.OilName AS [Oil name], COALESCE(Cautions.Description, 'No
> > > description available') AS Caution
> > > FROM Cautions
> > > INNER JOIN OilCautions ON Cautions.CautionID = OilCautions.CautionID
> > > RIGHT OUTER JOIN Oils ON OilCautions.OilID = Oils.OilID
> > > ORDER BY Oils.OilName
> > > I want to reference OilCautions.OilID from the above view in another
> > > view. But query analyzer tells me there's no such column. In EM the
> > > only columns that show up in view designer are Description and
> > > Oilname.
> > >
> > > Does a view that calls another view only have access to the output
> > > columns of the 1st view? I need to access OilId, so do I need to put
> > > it in the 1st view, too? If that's true, can I hide that column, make
> > > it there but invisible? :)
> > >
> > > TIA!
> > > patrick
> >
> >
>
>
- Next message: Aaron Weiker: "Re: Select from 4 tables with COUNT(*)"
- Previous message: --CELKO--: "Re: "Macro" statement"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
