I have a query by
$ques=mysql_query("SELECT field.field FROM field LEFT OUTER JOIN skill_freelancer ON skill_freelancer.sname=field.field WHERE skill_freelancer.id=$sr");
here $sr is a id 1
my table are
field skill_freelancer
------------------- --------------------------
id | field id | sname
1 | html 1 | html
2 | php 1 | php
3 | c
The output is html,php but i need only "c" could anyone help in the query