title: Using Castle ActiveRecord to query from multiple tables
body: <p>So I've been using Castle ActiveRecord for my latest project and for the most part I like it a lot. Now I'm trying to figure out how to execute a simple join query with AR and I'm not seeing it.</p>
  
  <p>So I have an Article table and an article could have many tags associated to it. This is the attribute in the Article class:</p>
  
  <pre><code>[HasAndBelongsToMany(typeof(Tag), Table="ArticleTags", ColumnKey="ArticleID", ColumnRef="TagID")]
      public IList&lt;Tag&gt; Tags {
              get
              {
                  return m_tagList;
              }
              set
              {
                  m_tagList = value;
              }
      }
  </code></pre>
  
  <p>There's a Tag class that contains the name and ID of the tag. There's the required bridge/association table which AR can handle without an explicit class. </p>
  
  <p>So now I just want to get all articles that have a given tag name. Thus far, I haven't figured how to do that in AR. The SQL is easy. Trying to reproduce for AR, not so much.</p>
  
  <p>Any help here would be much appreciated.</p>