Hi all, Have been trying to get the syntax of a delete query in MySQL for days and get nothing but errors. Any MySQL Gurus out there can help? I have tried all the versions and variations I can find on the web site, this is V3 of MYSQL. I either get a syntax error and the query seems to be truncated or I get an invalid table name. I have tried standard SQL syntax, have tried the 'USING' command etc etc. Any ideas?
Table 1: user Table 2: user_preferences I want to delete records from the user-preferences table based on a field 'department' in the user table being '2000' The table can be joined from user.id=user_preferences_userid ------------------------------------ OLMC Simon Bryan IT Manager [EMAIL PROTECTED] LMB 14 North Parramatta Direct Number:88381200 SwitchBoard: 96833300 fax: 98901466 mobile: 0414238002 ------------------------------------ -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
