On 03/09/2010 9:26 p, Hank wrote:
On Fri, Sep 3, 2010 at 6:23 AM, Jangita wrote:
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 WHER
On 03/09/2010 9:27 p, Hank wrote:
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 * FRO
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
On 9/3/2010 6:23 AM, Jangita wrote:
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
I have a view such as:
create view combo as
select * from table1
union
select * from table2;
...
(I've also tried "UNION ALL" with the same results).
...
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
I have a view such as:
create view combo as
select * from table1
union
select * from table2;
Where table1 and table2 are very large and identical and have a
non-unique key on field "id"..
wh
