|
|
Posted by Oliver Grδtz on 12/03/07 12:16
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
--
Bender: "There's someone you know!"
[Futurama 101]
Navigation:
[Reply to this message]
|