ST Alpha - "I think something like" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 153

In response to "SQL question. I can wind up exporting to Excel and doing it that way but trying to learn." by Dano

I think something like

Posted by oblique (aka kkuphal) Oct 31 '24, 12:55

SELECT DISTINCT VALUE FROM TABLE01
WHERE CONCAT('##',VALUE) NOT IN (SELECT ##VALUE FROM TABLE02)

I think the other way to do it would be something like

SELECT DISTINCT VALUE FROM TABLE01
WHERE VALUE NOT IN (SELECT RIGHT(##VALUE,LEN(##VALUE)-2) FROM TABLE02)

Responses:

Thanks! The CONCAT option worked -- nm - Dano Oct 31, 13:12
I like your first option but prefer a join - Bayronmax Oct 31, 12:59 1
- *high five* -- nm - JaxSean Oct 31, 13:05

Post a message top

I think something like

Replies are disabled on threads older than 7 days.