$q->where('hotfix.os=hotfixdata.os',null);

[eluser]Unknown[/eluser]
Hello everyone i'm attempting to replicate a working SQL statement i've verified it is working due to running the SQL statement from SQLYog (I'm unable to post the code due to limitations on the board?)

The aspect that is causing the problem is this:
$q->where('hotfix.os=hotfixdata.os',null);
both hotfix and hotfixdata have been joined with $q->join(...);
if this line is remove all works but more data is return than should be, however i have to JOIN on hotfix.hotfixid=hotfixdata.hotfixid

I've also tried using $q->query which again returns another error.