Hi.. Actually i need to get User''s name Contact''s name and it''s department id and it''s Authority id and authority name. so i done following query. but its so long. I don''t know about join queries. so pls help me how can i implemend join query instead of below query.... user = UserInfo.find_by_id(user_id) =>Using this query I get user.first_name contact = UserInfo.find_by_id(contact_id) =>Using this query I get contact.first_name and contact.department_id authority = PrivilegeInfo.find(:first, :conditions => [ "user_id =? and department_id =? ", contact_id,contact.department_id]) =>Using this query I get authority.authority_id authority_name = UserInfo.find_by_id(authority.authority_id) =>Using this query I get authority_name.first_name Thanks in advance -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---