[EMAIL PROTECTED] writes:
> >Description:
>
> Take two tables (call them a and b), which have identical structures. Table a
> has no rows, table b has some (say 10) rows. If you do this:
>
> select * from a union select * from b limit 0,5
>
> It works as expected. Now do this:
>
> select *
>Description:
Take two tables (call them a and b), which have identical structures. Table a
has no rows, table b has some (say 10) rows. If you do this:
select * from a union select * from b limit 0,5
It works as expected. Now do this:
select * from a union select * from b limit 5,5
Now y