Is it possible to create stored procedure in manner similar to this:
"
CREATE PROCEDURE GetInfo()
BEGIN
  SELECT TT.Name,
              NT.Notes
  FROM    TestTable AS TT
              JOIN
              NextTable AS NT
  ON        TT.ID = NT.ID;
END;
".

Zdzislaw,

<< Is it possible to create stored procedure in manner similar to this: >>

Yes, use this:

CREATE PROCEDURE GetInfo()
BEGIN
  DECLARE TestCursor CURSOR WITH RETURN FOR TestStmt;

  PREPARE TestStmt FROM 'SELECT TT.Name, NT.Notes
                                               FROM TestTable AS TT
                                               JOIN NextTable AS NT ON
TT.ID = NT.ID';
  OPEN TestCursor;
END;

--
Tim Young
Elevate Software
www.elevatesoft.com