List:General Discussion« Previous MessageNext Message »
From:Graeme B. Davis Date:February 29 2000 4:41pm
Subject:LEFT JOIN/JOIN question
View as plain text  
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

Thread
Compilation problemsSr. Jim Brown29 Feb
  • LEFT JOIN/JOIN questionGraeme B. Davis29 Feb
    • Re: LEFT JOIN/JOIN questionsinisa29 Feb
  • Re: Compilation problemssinisa29 Feb
  • Re: Compilation problemssasha29 Feb
  • Re: LEFT JOIN/JOIN questionGraeme B. Davis29 Feb
  • Re: LEFT JOIN/JOIN questionGraeme B. Davis29 Feb