<div>Hi All</div>
<div>I am trying to write a sql query in D7.</div>
<div> </div>
<div><font color="#808080"><font color="#808080">
<p><font color="#000000">SELECT id, exp, name FROM {resubmt_users_skills} LEFT JOIN {resubmt_skill_ids} USING (id) WHERE resubmt_users_skills.uid = $user.uid</font></p>
<p><font color="#000000">The above query I want to write in D7.</font></p>
<p><font style="BACKGROUND-COLOR:#ccffff" color="#000000"> $query = db_select('resubmt_users_skills' , 'us');<br> $query->leftJoin('resubmt_skill_ids' , 'si');<br> $query->condition('USING(id)');<br>
$query->condition('us.uid = :uid' , array(':uid' => $user->uid));<br> $result = $query->execute()->fetchAssoc();<br></font></p>
<p><font color="#000000"> Looks above syntaxt is not correct. Can somebody pls tell me whats the fault here and solution for that.</font></p>
<p><font color="#000000"></font> </p>
<p><font color="#000000">Thanks</font></p>
<p><font color="#000000">Kamal</font></p>
<p><font color="#000000"></font> </p>
<p><font color="#000000"> </font></p></font></font></div>