Hi, I have a query that runs in Microsoft Access against my mysql database just fine. It is:
UPDATE discussion_categories AS discussion_categories_1 INNER JOIN discussion_categories ON discussion_categories_1.parent_1_text = discussion_categories.name SET discussion_categories_1.parent_1 = [discussion_categories].[category_id]; I tried to write this in mysql but couldn't figure it out. Is it possible to join a table on itself in mysql? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]