RE : Re: RE : Re: Left outer joins, where clause and table_names

--- [EMAIL PROTECTED] a écrit : > tom wang wrote: > > Hi, > > > > > > First, sorry, I kind of messed of with copy and > > pasting (it's been a long day) and forgot to strip > all > > the useless part (for the sake of explaining my > > problem) between select and from... > > > > SELECT * FROM

Re: RE : Re: Left outer joins, where clause and table_names

tom wang wrote: Hi, First, sorry, I kind of messed of with copy and pasting (it's been a long day) and forgot to strip all the useless part (for the sake of explaining my problem) between select and from... SELECT * FROM projects LEFT OUTER JOIN forums ON forums.work_id = projects.id AND fo

RE : Re: Left outer joins, where clause and table_names

Hi, First, sorry, I kind of messed of with copy and pasting (it's been a long day) and forgot to strip all the useless part (for the sake of explaining my problem) between select and from... SELECT * FROM projects LEFT OUTER JOIN forums ON forums.work_id = projects.id AND forums.work_type = 'P