<div>Thanks <font color="#000000">Nicolas</font><br>Tried your suggestion. It worked. Thanks.</div>
<div> </div>
<div>Nancy, I did not understand your comment "do not convert select query", can you kindly elaborate on it.</div>
<div> </div>
<div>Thanks </div>
<div>Kamal</div>
<div><br> </div>
<div class="gmail_quote">On Fri, Sep 21, 2012 at 2:10 PM, Nicolas Poulain <span dir="ltr"><<a href="mailto:nico.poulain@gmail.com" target="_blank">nico.poulain@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">2012/9/21 Kamal Palei <<a href="mailto:palei.kamal@gmail.com">palei.kamal@gmail.com</a>>:<br>
<div>
<div class="h5">> Hi All<br>> I am trying to write a sql query in D7.<br>><br>><br>> SELECT id, exp, name FROM {resubmt_users_skills} LEFT JOIN<br>> {resubmt_skill_ids} USING (id) WHERE resubmt_users_skills.uid = $user.uid<br>
><br>> The above query I want to write in D7.<br>><br>> $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>
><br>> Looks above syntaxt is not correct. Can somebody pls tell me whats the<br>> fault here and solution for that.<br><br></div></div>Try out this syntax :<br>
<div class="im">$query = db_select('resubmt_users_skills' , 'us');<br></div>$query->leftJoin('resubmt_skill_ids' , 'si', '<a href="http://si.id/" target="_blank">si.id</a> = <a href="http://us.id/" target="_blank">us.id</a>');<br>
<div class="HOEnZb">
<div class="h5">$query->condition('us.uid = :uid' , array(':uid' => $user->uid));<br>$result = $query->execute()->fetchAssoc();<br><br><br><br></div></div><span class="HOEnZb"><font color="#888888">--<br>
Nicolas poulain<br>--<br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></font></span></blockquote></div><br>