Mysql Join query help

[eluser]kikz4life[/eluser]
Hi, in CI ver. 1.6.3 this synthax is ok but in 1.7.2 it cause an internal server error to me. Just want to know if anyone else experience this?

Code:

$this->db->join('sec_dataset k','ar_so.status=k.data_value AND k.data_code = "TRAN_STATUS"','left');

And also could anyone help me rewrite this code that is applied in 1.7.2 ci version?

thanks
-Dean

[eluser]imn.codeartist[/eluser]
paste your full code here