problems problems problems

So, I have this blog... in work.  Its a typical community blog, with many users and many departments.  I've just rolled it out, and so far it works really well.  The problem is that my boss asked me to do something today that I can't do really easily.  He wanted me to see if we could segregate certain departments from being seen by other departments.  Now, on the face of it, this shoulsn't be too much of an issue.  The problem lies in that up to now I had been developing this blog from the perspective of using a "select * from blog where {filter} order by {order} {sort}". Depending on whether you are logged in or not, and the criteria you specify, {filter}, {sort} and {order} are changed.  Now, there doesn't seem to be a very easy way to select entries from one table based on criteria specified elsewhere and display them in the kind of page I have built.  It CAN be done, but I'd have to re-engineer the page to use a datagrid or a repeater, and I just don't have the time for that.  ::sigh::  I guess it'll get relegated to version 2.0.  I hate not getting things done quickly.