You should be able to add the inner join. There is probably a bug in CS4 and another server behavior on your page that prevents you from editing the recordset when the other server behavior is on the page. You should be able to edit it and add the join statement in code view.