ST Alpha - "it's a weird limitation of the system I'm working with" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 164

In response to "on the first one your join is on id to parent_id. "where id not in [parent_id's]". And wouldn't a left join work?" by JaxSean

it's a weird limitation of the system I'm working with

Posted by oblique (aka kkuphal) Nov 5 '21, 08:18

I can only modify the WHERE clause. Basically I'm configuring views inside the ticketing system and I can write SQL but only WHERE statements used to build the views.

Responses:

ah. It could be because there's blanks (non-NULLs) so it joins on those? dunno. -- nm - JaxSean Nov 5, 08:23 1
- I suspect it some weird thing with uniqueidentifiers because that's what those IDs are - oblique Nov 5, 08:29

Post a message top

it's a weird limitation of the system I'm working with

Replies are disabled on threads older than 7 days.