Re: Really worried about DELETE statement - THANKS

2007-02-26 Thread mos
At 07:51 PM 2/26/2007, Miles Thompson wrote: At 10:42 PM 2/25/2007, mos wrote: At 06:13 PM 2/25/2007, Miles Thompson wrote: Would someone please check this delete query? This should delete all rows from the geodesic_user_data that have no match in the subscriber table, but another set of ey

Re: Really worried about DELETE statement - THANKS

2007-02-26 Thread Miles Thompson
At 10:42 PM 2/25/2007, mos wrote: At 06:13 PM 2/25/2007, Miles Thompson wrote: Would someone please check this delete query? This should delete all rows from the geodesic_user_data that have no match in the subscriber table, but another set of eyes would be appreciated. DELETE geodesic_use

Re: Really worried about DELETE statement

2007-02-25 Thread mos
At 06:13 PM 2/25/2007, Miles Thompson wrote: Would someone please check this delete query? This should delete all rows from the geodesic_user_data that have no match in the subscriber table, but another set of eyes would be appreciated. DELETE geodesic_user_data FROM geodesic_user_data LEFT

Really worried about DELETE statement

2007-02-25 Thread Miles Thompson
Would someone please check this delete query? This should delete all rows from the geodesic_user_data that have no match in the subscriber table, but another set of eyes would be appreciated. DELETE geodesic_user_data FROM geodesic_user_data LEFT JOIN subscriber ON geodesic_classifieds_userda