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
>> select * from table2;
>> (I've also tried "UNION ALL" with the same results).
> I think mysql is selecting ALL the records from both tables then
> applying the where clause to all the data from table 1 and table 2 (I
> think - guys correct me if I'm wrong)
Jangita is correct. Read the bottom of
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN