|
Posted by Oliver Grδtz on 12/03/07 11:00
Jerry Stuckle schrieb:
> Oliver GrΓ€tz wrote:
>> If your query is "too complicated", you can always
>> work with subqueries:
>>
>> SELECT wanted_field_1,wanted_field_2
>> FROM (SELECT with your complicated query)
>> AS subtable [...]
>
> Subqueries are almost never correct. Joins are much better.
1. This was an explicit response to "my query is too complicated" and
the whole complicated query should be encapsulated as a subquery.
2. You are not stating your argument with any explanation. It reads like
"Blue is lame, red is much better."
3. Subqueries are aqn important part of SQL nad the fact that they can
often be replaced by joins does not render them incorrect. There is
always more than one way to do it.
4. Please stop full-quoting when you are in fact just anserinfg to one
sentence.
OLLi
--
According to my calculations the problem doesn't exist.
Navigation:
[Reply to this message]
|