Join query

[pkj]

I have one table "Farmer" in which i store farmer name,village id,gut id and when display this information in grid,i want display farmer name,village name (this name is retrieve from village table in which[village ID,Village name],but some farmer have no village id ,but i want show information in grid his name and after vilage name is blank,which query i use?

[dan sh]

What have you tried so far?

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

[Pranay Rana]

i think for this try left outer join so that it get all the farmer even the village is not present for that