Hello, I''m creating a multilingual blog, where a translator would translate single posts into several languages. I''m having some trouble searching and comparing records. My database is set up like this: Posts: id, body, original_id, language_id Languages: id, name A single post, translated into several languages is grouped by the number in ''original_id'', like this: http://www.harryvermeulen.nl/database.jpg I''m looking for a way to find all the posts in (for example) english, that do not have a translation in (for example) japanese yet. I hope I''m making sense. I''m fairly new at web development, I hope I''m in the right place to ask this question. Kind regards, Harry -- 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 -~----------~----~----~----~------~----~------~--~---