Query for getting users_name and caste_name

I have different fields in different tables like (in one table i have users_name, in another table i have caste_name of that persons) like this I have fields how to write query for getting users_name and caste_name

[b]Question asked by visitor Eswar[/b]

You need to join the tables based on some common field to retrive the required record.