On Thu, Oct 21, 2010 at 1:37 PM, Rob Sargent <robjsarg...@gmail.com> wrote:
> > > On 10/21/2010 10:27 AM, Scott Marlowe wrote: > > On Thu, Oct 21, 2010 at 9:33 AM, Brian Hirt <bh...@me.com> wrote: > >>> > >>> There are only two tables in the query. > >>> > >> > >> Tim, > >> > >> No, your query is written incorrectly. I don't understand why you come > on to this list all hostile and confrontational. Regardless, people still > try to help you and then you still ignore the advice of people that are > giving you the solutions to your problems. > > > > Maybe he's used to paid commercial support where people are often > > quite rude and hostile to the support staff to try and "motivate" them > > or something? I've seen it before for sure. > > > > Again, OP, what does EXPLAIN say about this query? > > > > Maybe I should re-read, but I didn't feel any confrontation. > Frustration for sure. OP has clearly tried pretty hard, on some tricky > bits too, but I'm betting all for naught if (as seems likely) it's just > mistaken sql. "update from" is NOT straight forward. > > i had the same feeling than brian and scott, but i am one of the "questioners" not the "answerers" on the list, so i didnt said anything... but the "i-am-touching-many-parameters-and-doesnt-work" and then complain is not one of the best strategies... the SQL sentence is far more complicated than it pretended to be... -- Roberto Scattini ___ _ ))_) __ )L __ ((__)(('(( ((_)