Scott Kulik wrote: > Frederick Cheung wrote: >> On Apr 25, 1:57�am, Scott Kulik <[email protected]> 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?
Then please spend some quality time with an SQL reference. If you can't write simple joins, then you are not yet ready to develop Web applications that use SQL databases. Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] -- 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
