"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote:
> 7.5.5.2 Foreign Key Constraints
>
> Hi programmers,
>
> I try to code this
>
> CREATE TABLE EMPLOYEE
> (
> FNAME VARCHAR(15) NOT NULL,
> MINIT CHAR,
> LNAME VARCHAR(15) NOT NULL,
> SSN
[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 *