Re: SQL meaning

  • From: amonte <ax.mount@xxxxxxxxx>
  • To: "Jared Still" <jkstill@xxxxxxxxx>
  • Date: Tue, 28 Oct 2008 18:18:20 +0100

hmmm it returned different results

omg, I need to get some sql courses because this query looks too advanced
for me :-(

know any good sql books?


Alex


On Tue, Oct 28, 2008 at 5:29 PM, Jared Still <jkstill@xxxxxxxxx> wrote:

> On Tue, Oct 28, 2008 at 8:48 AM, amonte <ax.mount@xxxxxxxxx> wrote:
>
>> So the query cannot be wriiten as follows?
>> SELECT   userobj.ID, NAME, summary
>>     FROM userobj
>>    WHERE userobj.NAME LIKE 'A%'
>>      *AND attr1 IN ('#ID#TOP')*
>>      AND userobj.ID IN (
>>             SELECT ID
>>               FROM userattr
>>              WHERE ( attr1 IN (
>>                           SELECT ID
>>                             FROM orgattr
>>                            WHERE orgattr.attrname =
>> 'CONTAINEDBYOBJECTGROUP'
>>                              AND attrval IN ('#ID#TOP'))
>>                    ))
>> ORDER BY userobj.ID
>>
>>
> Whether or not that works is dependent on the data.
>
> The original query included "where attr1 IN ('#ID#TOP') OR ...".
>
> The modified query cannot return the same results unless all
> occurrences of "attrval = '#ID#TOP'" also have
> "attrname = 'CONTAINEDBYOBJECTGROUP'"
>
> You really need to know the data, and whether or not that condition is
> enforced
> if it exists.
>
> Have you tried running the query?
>
> Jared
>
>
>

Other related posts: