+ "post.reply_to_post_id as o_posts_reply_to_post_id, post.subject as o_posts_subject, "
+ "post.tenant_id as o_posts_tenant_id "
+ "from tbl_vw_discussion as disc left outer join tbl_vw_post as post "
+ " on disc.discussion_id = post.discussion_id "
+ "where (disc.tenant_id = ? and disc.discussion_id = ?)",
new JoinOn("discussion_id", "o_posts_discussion_id"),
aTenantId,
aDiscussionId);
}