"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
discussion_categories1.`parent_1_text` = discussion_categories.name
> -Original Message-
> From: Jonathan Patton
> Sent: Wednesday, July 23, 2003 8:39 AM
> To: [EMAIL PROTECTED]
> Subject: update query using inner join on same table
>
>
> Hi,
>
> I have
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
