From: Hank
Date: September 3 2010 7:27pm
Subject: Re: question about VIEWS in 5.1.x
List-Archive: http://lists.mysql.com/mysql/222844
Message-Id: <AANLkTimW36D4GUKQ1NH0=P5O30JNpwWxu-+K9hZZo3M-@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1

On 02/09/2010 8:30 p, Hank wrote:
>>
>> Simple question about views:
>>
>>
> Hank,
> Have you tried "running away from the problem :-)" by doing...
>
> CREATE PROCEDURE `combo`(theid INT)
> BEGIN
>        (SELECT * FROM table1 WHERE id = theid)
>        UNION
>        (SELECT * FROM table2 WHERE id = theid);
>    END$$
>
> then calling it using
>
> call combo(value);
>

Wow - thanks. This works perfectly.   I'm assuming I can use "call
combo(value)" in PHP and it returns the result set as if it were a
proper table?

-Hank