I’m not expert, but site_account is a table, not a column. And a standard join won’t work because you’re looking for stuff that’s not in the table. Don’t know if this will work, but perhaps something along the lines of :conditions => “id not in (select id from site_account)”
alternatively you might be able do it in rails with something like Member.find(:all).delete_if { |m| !m.site_account.nil? }
Hope this of some help…
…
John Browning