view calling a view problem
From: Patrick (psully_at_nospam.eatel.net)
Date: 01/25/05
- Next message: Richard Lawson: "Grouping by hour, day, month, etc"
- Previous message: Aaron Weiker: "Re: stored procedure xp_cmdshell"
- Next in thread: Aaron Weiker: "Re: view calling a view problem"
- Reply: Aaron Weiker: "Re: view calling a view problem"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 24 Jan 2005 20:58:53 -0600
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: Richard Lawson: "Grouping by hour, day, month, etc"
- Previous message: Aaron Weiker: "Re: stored procedure xp_cmdshell"
- Next in thread: Aaron Weiker: "Re: view calling a view problem"
- Reply: Aaron Weiker: "Re: view calling a view problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
