CodeIgniter Forums

Full Version: again abaut the third parameter in active record join
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]Unknown[/eluser]
thank you so much for the last time,but still a got some problems
I'm using a normal join(active record) but now the field that it use to join the tables could be null in the first one and of course in the other there's no record, for that reason I can't have the result of the query that I'm doing,I thought that maybe with one of those parameters I could do that work, I meant have the result of my query even if that field is NUll.

Table uno Table dos
id valor valor A id_table_uno valor_otro
5 aadf ygghgh 5 adsdfgsdf
null fgfgfg trtrrtrt

What I need is do that query with those tables join by id,and if the id exit in the second table I want those records or if the id in the first one is NULL just have the record in this one table..

Thanks

I'm not very good in inglish that's why I make that' why example, sorry abaut that.