• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
again abaut the third parameter in active record join

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..


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

Messages In This Thread
again abaut the third parameter in active record join - by El Forum - 05-17-2008, 12:55 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.