find and has_one relationships

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