Re: Comprable technique to Yukon's "WITH", in 2000?
From: Steve Kass (skass_at_drew.edu)
Date: 08/04/04
- Next message: John Kane: "Re: Error on Full-Text"
- Previous message: Tea C: "RE: Select Statement Help on count"
- In reply to: Ian Boyd: "Re: Comprable technique to Yukon's "WITH", in 2000?"
- Next in thread: Ian Boyd: "Re: Comprable technique to Yukon's "WITH", in 2000?"
- Reply: Ian Boyd: "Re: Comprable technique to Yukon's "WITH", in 2000?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 03 Aug 2004 23:10:24 -0400
Ian,
The join is there:
from Nodes N, @t T
where N.ParentNodeID = T.NodeID
It's identical to this, which uses JOIN .. ON
from Nodes N join @t T
on N.ParentNodeID = T.NodeID
SK
Ian Boyd wrote:
>> Not that my track record is so good here, but I think this function
>>will generate the same results as Hugo's solution. I used the tables as
>>he had modified them.
>>
>>
>
>Thanks for the sample code (from both of you).
>
>Unfortuanly, i don't understand pretty much all of it.
>
>Which sucks, since i'd be the person to have to implement it, and explain it
>to 5 other guys when they need to use it.
>
>Personally, i can't visualize any join that doesn't use "EQUALS" predicate.
>
>And if i can't visualize it, i can't understand it, figure it out, write it,
>learn it, or maintain it.
>
>
>
>But, it's the end of a long day. i've read 4 or 5 articles, and dozens of
>posts - and i'm tired.
>
>i'll pick it up again when the deadline is closer, and i really need to have
>something done.
>
>
>
>
- Next message: John Kane: "Re: Error on Full-Text"
- Previous message: Tea C: "RE: Select Statement Help on count"
- In reply to: Ian Boyd: "Re: Comprable technique to Yukon's "WITH", in 2000?"
- Next in thread: Ian Boyd: "Re: Comprable technique to Yukon's "WITH", in 2000?"
- Reply: Ian Boyd: "Re: Comprable technique to Yukon's "WITH", in 2000?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
