|
|
Posted by Jerry Stuckle on 12/03/07 12:41
Oliver Grätz wrote:
> Rik Wasmus schrieb:
>> General concensus is joins are both more portable and in most cases a lot
>> faster. You can use subqueries offcourse, that doesn't mean it's the best
>> solution. In php <?=$foobar ?> is possible, yet we all strongly advise
>> against it...
>
> Yes it IS true, but whether that's true is off-topic here since my
> advice was a direct response to someone who said his query was too
> complex. So, telling him to change it and use more joins is pointless.
> The example was only brought up for one reason: to illustrate the
> possibility to completely detach the ORDER BY and LIMIT part from the
> rest of the "complicated query" as leverage against the "too complicated
> to change" argument.
>
> OLLi
>
And for that question he should have been directed to a SQL newsgroup
instead of being given a bad answer.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|