Re: syntax help - updating multiple rows

From: SpaceMarine <spacemarine_at_mailinator.com>
Date: Fri, 1 Feb 2008 11:11:01 -0800 (PST)
Message-ID: <a6ec0e37-60df-43c7-aef2-a4d1aef684b9@v46g2000hsv.googlegroups.com>


On Jan 31, 1:10 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> Of course - the join should be within the inner, not the outer.
> You are correct.

doh, i should have realized that.

> Inner and outer have their respective where clauses.
> You still seem to miss some tables in the from clause, where
> you do have aliases:

ah yeah, i forgot those when copy & pasting some changes.

...this looks like what i need! thank you!!

sm Received on Fri Feb 01 2008 - 13:11:01 CST

Original text of this message