"Jonathan Patton" <[EMAIL PROTECTED]> wrote:
> 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_ca
I answered my own question, this works for joining a table on itself and doing an
update query:
update
discussion_categories discussion_categories1, discussion_categories
set
discussion_categories1.parent_1 = discussion_categories.category_id
where
discu
