On Nov 30, 2007 10:00 PM, tedd <[EMAIL PROTECTED]> wrote:
> At 2:00 PM +1100 11/30/07, Chris wrote:
> >>Out of curiosity, what SQL server (and version) are you using? I
> >>currently have MySQL 5.0.33 on my dev box and I had no problem with the
> >>query I gave you. Perhaps it's a version issue. Th
At 9:52 AM -0500 11/30/07, Daniel Brown wrote:
On Nov 29, 2007 11:17 PM, Robert Cummings <[EMAIL PROTECTED]> wrote:
Rob,
The version difference is probably right on the nose. If I
remember correctly, you couldn't do that in the long-popular 3.23,
which *gasp!* is still used by some web
At 2:00 PM +1100 11/30/07, Chris wrote:
Out of curiosity, what SQL server (and version) are you using? I
currently have MySQL 5.0.33 on my dev box and I had no problem with the
query I gave you. Perhaps it's a version issue. There really shouldn't
be a problem updating a table that also occurs in
tedd <[EMAIL PROTECTED]> wrote:
> Hi gang:
>
> I found why the JOIN didn't work for me in this instance, which was I
> needed to create a third table and JOIN what I needed in that table
> from the other two.
>
> My problem was that I was trying to alter one of the tables in the
> JOIN.
On Nov 29, 2007 11:17 PM, Robert Cummings <[EMAIL PROTECTED]> wrote:
> On Fri, 2007-11-30 at 14:00 +1100, Chris wrote:
> > > Out of curiosity, what SQL server (and version) are you using? I
> > > currently have MySQL 5.0.33 on my dev box and I had no problem with the
> > > query I gave you. Perhaps
On Fri, 2007-11-30 at 14:00 +1100, Chris wrote:
> > Out of curiosity, what SQL server (and version) are you using? I
> > currently have MySQL 5.0.33 on my dev box and I had no problem with the
> > query I gave you. Perhaps it's a version issue. There really shouldn't
> > be a problem updating a tab
Out of curiosity, what SQL server (and version) are you using? I
currently have MySQL 5.0.33 on my dev box and I had no problem with the
query I gave you. Perhaps it's a version issue. There really shouldn't
be a problem updating a table that also occurs in the select query since
the select quer
On Thu, 2007-11-29 at 18:43 -0500, tedd wrote:
> Hi gang:
>
> I found why the JOIN didn't work for me in this instance, which was I
> needed to create a third table and JOIN what I needed in that table
> from the other two.
>
> My problem was that I was trying to alter one of the tables in the
Hi gang:
I found why the JOIN didn't work for me in this instance, which was I
needed to create a third table and JOIN what I needed in that table
from the other two.
My problem was that I was trying to alter one of the tables in the
JOIN. While that might be possible it didn't appear so in
9 matches
Mail list logo
