Re: 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! ...........................................................