At 6:53 PM -0700 7/14/07, Steffan A. Cline wrote:
I was trying to reduce a set of queries and ran into this:
insert into forums (forum_reply_id, forum_dev_id, forum_subject,
forum_message) values (0, 1, (select forum_subject from forums where
forum_id=3 ), "I figured this one needed a reply too
Alliance Member
---
> From: Mogens Melander <[EMAIL PROTECTED]>
> Date: Sun, 15 Jul 2007 04:02:18 +0200 (CEST)
> To: "Steffan A. Cline" <[EMAIL PROTECTED]>
> Cc:
> Subject: Re: New error to me...
>
>
> On Sun, July 15, 2007 03:53, Steffan A. Cl
On Sun, July 15, 2007 03:53, Steffan A. Cline wrote:
> I was trying to reduce a set of queries and ran into this:
>
>
> insert into forums (forum_reply_id, forum_dev_id, forum_subject,
> forum_message) values (0, 1, (select forum_subject from forums where
> forum_id=3 ), "I figured this one needed
I was trying to reduce a set of queries and ran into this:
insert into forums (forum_reply_id, forum_dev_id, forum_subject,
forum_message) values (0, 1, (select forum_subject from forums where
forum_id=3 ), "I figured this one needed a reply too.")
yields:
error: You can't specify target table
