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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
