[SOLVED] OUTER JOIN

[Welling]

I'm trying to do a sql outer join:

 

SELECT ft.id, ft.ult_resp, fl.fecha

FROM forotemas ft

LEFT OUTER JOIN foroleidos fl

ON fl.id_tema = ft.id

WHERE fl.id_usu = "2"

 

But sometimes there are a value in foroleidos for each of forotemas and don't works like "outer join" including all results of forotemas although the fl.fecha value were null like this must do,

What happens?

 

Thanks

[corbin]

I'm sorry, but... what?

 

 

 

Do you mean it pulls empty rows sometimes?  If that's your problem, just use a JOIN.

[Barand]

needs a small tweak

SELECT ft.id, ft.ult_resp, fl.fecha
FROM forotemas ft
LEFT OUTER JOIN foroleidos fl
ON fl.id_tema = ft.id AND fl.id_usu = "2"

 

WHERE conditions on a right table need to be part of the JOIN conditions

[Welling]

needs a small tweak

SELECT ft.id, ft.ult_resp, fl.fecha
FROM forotemas ft
LEFT OUTER JOIN foroleidos fl
ON fl.id_tema = ft.id AND fl.id_usu = "2"

 

WHERE conditions on a right table need to be part of the JOIN conditions

 

Thank you, it works