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
