Re: [PHP] Join question [solved]

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
JOIN. While that might be possible it didn't appear so in my current
problem.

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 query should take place before the insert.

Cheers,
Rob.
--
............................................................
SwarmBuy.com - http://www.swarmbuy.com

Leveraging the buying power of the masses!
............................................................
.

Quantcast