Graeme B. Davis writes:
> I have a straight join that works:
>
> SELECT m.sbj, r.assignedto FROM mails AS m, remedy.remedy AS r WHERE
> (m.type='' OR m.type IS NULL) AND m.ticketnum=r.ticket ORDER BY m.date DESC;
>
> But I can't turn this into a LEFT JOIN for some reason.
>
> Is this how I would do it? :
>
> SELECT m.sbj, r.assignedto FROM mails AS m, remedy.remedy AS r LEFT JOIN
> remedy.remedy ON r.ticket=m.ticketnum WHERE (m.type='' OR m.type IS NULL)
> AND m.ticketnum=r.ticket ORDER BY m.date DESC;
>
> (for this particular query, I get:
> ERROR 1114: The table 'SQL3f_0' is full
> )
>
> Any ideas?
>
> Thanks,
> Graeme
>
> p.s. remedy is the db and it has a table called remedy as well
Hi!!
Start your MySQL server with --big-tables support or set BIG_TABLES
run time option.
There are other options, but available under 3.23.
You are eveidently using 3.22.
Regards,
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
