| |
|
|
| | Здравствуйте!
Помогите упростить процедуру
CREATE PROCEDURE BASE.DocumentOpen(IN Name VARCHAR(32))
SQL SECURITY INVOKER
BEGIN
SELECT
Page.Value AS Page,
Descriptions.Value AS Description,
Keywords.Value AS Keyword,
Titles.Value AS Title,
Bodys.Value AS Body,
Created.Value AS Created,
Changed.Value AS Changed,
Name.Value AS Name,
Surname.Value AS Surname,
Nickname.Value AS Nickname
FROM
Documents
LEFT OUTER JOIN Names Page
ON Documents.ID_Name = Page.ID
LEFT OUTER JOIN Descriptions
ON Documents.ID_Description = Descriptions.ID
LEFT OUTER JOIN Keywords
ON Documents.ID_Keyword = Keywords.ID
LEFT OUTER JOIN Titles
ON Documents.ID_Title = Titles.ID
LEFT OUTER JOIN Bodys
ON Documents.ID_Body = Bodys.ID
LEFT OUTER JOIN Attributes
ON Documents.ID_Attribute = Attributes.ID
LEFT OUTER JOIN Dates Created
ON Documents.ID_Created = Created.ID
LEFT OUTER JOIN Dates Changed
ON Documents.ID_Changed = Changed.ID
LEFT OUTER JOIN Authors Author
ON Documents.ID_Author = Author.ID
LEFT OUTER JOIN Names Name
ON Author.ID_Name = Name.ID
LEFT OUTER JOIN Names Surname
ON Author.ID_Surname = Surname.ID
LEFT OUTER JOIN Names Nickname
ON Author.ID_Nickname = Nickname.ID
WHERE
Page.Value = Name AND
Attributes.Value = 'visible';
END
|
Спасибо! | |
| |
|
|
| |
|
|
| |
для: freeing
(15.07.2010 в 19:02)
| | | Процедура с одним единственным оператором SELECT, что может быть проще? | |
| |
|
|
