On Thu, Oct 21, 2010 at 1:37 PM, Rob Sargent
<robjsargent@gmail.com> wrote:
On 10/21/2010 10:27 AM, Scott Marlowe wrote:
> On Thu, Oct 21, 2010 at 9:33 AM, Brian Hirt <
bhirt@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?
>
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 __
((__)(('(( ((_)