It is in the Problems and Common Errors section of the manual.
Petio Tonev wrote:
>
> Hi,
>
> I have problem with left join on two table.
> Version on MySQL is 3.22.25 and it started under linux.
>
> The table is:
>
> tb_a:
> id (int)
> name_sid (int)
>
> tb_b:
> id (int)
> type_id (int)
> value (varchar)
>
> record on tb_a is 10000 and record on tb_b is 1000
>
> When I exec that query:
> SELECT a.*, b.value AS name
> FROM tb_a AS a LEFT JOIN tb_b AS b
> ON a.name_sid = b.id AND b.type_id = 1
> ORDER BY name
>
> ,I receive "MySQL error 1114: The table 'SQL7db1e_0' is full".
>
> How I can fix that.
>
> Best regards
> --
> Petio Tonev
> [EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
