[Rails] Re: help finding database items that lost parent item

Frederick Cheung wrote:
> On Apr 25, 1:57�am, Scott Kulik <li...@ruby-forum.com> wrote:
>> updating the database when a users has problems with their private
>> messages page.
>>
>> I'm wondering if someone knows a good way I could scan the the pm's
>> table and delete messages that no longer have a user for sent_to or
>> sent_from.
>>
>
> sounds like a job for a left join. If I were you I'd also setup a
> foreign key constraint so that this sort of thing can't happen in the
> future
>
> Fred

Thanks Fred. The problem is i don't know the syntax for the join. Did
you happen to know off the top of your head?
--
Posted via http://www.ruby-forum.com/.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.