MS Sql not in table
I am trying to wright a Microsoft sql statement that if on a piece of paper you draw two circles the intersect each other one labeled OH the other OLH I would get back all of OH not intersecting OLH. Here is what I got so far
select OE.pick_ticket_no, OLH.scanned
from p21_view_oe_pick_ticket as OE
LEFT JOIN jbi.dbo.order_logger_header as OLH On OE.pick_ticket_no = OLH.pickticket_no
where NOT EXISTS (
Select OLH.scanned
FROM jbi.dbo.order_logger_header as OLH-- )
where OLH.scanned = 'N')
this returns all including the interception where OLH.Scanned is = 'Y'
Thanks in Advance
Donald S Bossen
sql
asked Nov 14 '18 at 17:43
S bossenS bossen
365
add a comment |
I am trying to wright a Microsoft sql statement that if on a piece of paper you draw two circles the intersect each other one labeled OH the other OLH I would get back all of OH not intersecting OLH. Here is what I got so far
select OE.pick_ticket_no, OLH.scanned
from p21_view_oe_pick_ticket as OE
LEFT JOIN jbi.dbo.order_logger_header as OLH On OE.pick_ticket_no = OLH.pickticket_no
where NOT EXISTS (
Select OLH.scanned
FROM jbi.dbo.order_logger_header as OLH-- )
where OLH.scanned = 'N')
this returns all including the interception where OLH.Scanned is = 'Y'
Thanks in Advance
Donald S Bossen
sql
asked Nov 14 '18 at 17:43
S bossenS bossen
365
Which dbms is this???
– Eric
Nov 14 '18 at 17:47
Is says "MS SQL" in the title, so I guess SQL Server.
– NicVerAZ
Nov 14 '18 at 17:49
add a comment |
I am trying to wright a Microsoft sql statement that if on a piece of paper you draw two circles the intersect each other one labeled OH the other OLH I would get back all of OH not intersecting OLH. Here is what I got so far
select OE.pick_ticket_no, OLH.scanned
from p21_view_oe_pick_ticket as OE
LEFT JOIN jbi.dbo.order_logger_header as OLH On OE.pick_ticket_no = OLH.pickticket_no
where NOT EXISTS (
Select OLH.scanned
FROM jbi.dbo.order_logger_header as OLH-- )
where OLH.scanned = 'N')
this returns all including the interception where OLH.Scanned is = 'Y'
Thanks in Advance
Donald S Bossen
sql
asked Nov 14 '18 at 17:43
S bossenS bossen
365
I am trying to wright a Microsoft sql statement that if on a piece of paper you draw two circles the intersect each other one labeled OH the other OLH I would get back all of OH not intersecting OLH. Here is what I got so far
select OE.pick_ticket_no, OLH.scanned
from p21_view_oe_pick_ticket as OE
LEFT JOIN jbi.dbo.order_logger_header as OLH On OE.pick_ticket_no = OLH.pickticket_no
where NOT EXISTS (
Select OLH.scanned
FROM jbi.dbo.order_logger_header as OLH-- )
where OLH.scanned = 'N')
this returns all including the interception where OLH.Scanned is = 'Y'
Thanks in Advance
Donald S Bossen
sql
sql
asked Nov 14 '18 at 17:43
S bossenS bossen
365
asked Nov 14 '18 at 17:43
S bossenS bossen
365
asked Nov 14 '18 at 17:43
S bossenS bossen
365
asked Nov 14 '18 at 17:43
S bossenS bossen
365
asked Nov 14 '18 at 17:43
S bossenS bossen
365
365
Which dbms is this???
– Eric
Nov 14 '18 at 17:47
Is says "MS SQL" in the title, so I guess SQL Server.
– NicVerAZ
Nov 14 '18 at 17:49
add a comment |
Which dbms is this???
– Eric
Nov 14 '18 at 17:47
Is says "MS SQL" in the title, so I guess SQL Server.
– NicVerAZ
Nov 14 '18 at 17:49
Which dbms is this???
– Eric
Nov 14 '18 at 17:47
Which dbms is this???
– Eric
Nov 14 '18 at 17:47
Is says "MS SQL" in the title, so I guess SQL Server.
– NicVerAZ
Nov 14 '18 at 17:49
Is says "MS SQL" in the title, so I guess SQL Server.
– NicVerAZ
Nov 14 '18 at 17:49
add a comment |
1 Answer
1
active
oldest
votes
I don't see table OH on your original query. But you can do this.
SELECT col1, col2
FROM table1 OH
EXCEPT
SELECT col1, col2
FROM table2 OHL
This will get everything that's in OH, but not in OHL.
answered Nov 14 '18 at 17:52
EricEric
1,70711115
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53305995%2fms-sql-not-in-table%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I don't see table OH on your original query. But you can do this.
SELECT col1, col2
FROM table1 OH
EXCEPT
SELECT col1, col2
FROM table2 OHL
This will get everything that's in OH, but not in OHL.
answered Nov 14 '18 at 17:52
EricEric
1,70711115
add a comment |
I don't see table OH on your original query. But you can do this.
SELECT col1, col2
FROM table1 OH
EXCEPT
SELECT col1, col2
FROM table2 OHL
This will get everything that's in OH, but not in OHL.
answered Nov 14 '18 at 17:52
EricEric
1,70711115
add a comment |
I don't see table OH on your original query. But you can do this.
SELECT col1, col2
FROM table1 OH
EXCEPT
SELECT col1, col2
FROM table2 OHL
This will get everything that's in OH, but not in OHL.
answered Nov 14 '18 at 17:52
EricEric
1,70711115
I don't see table OH on your original query. But you can do this.
SELECT col1, col2
FROM table1 OH
EXCEPT
SELECT col1, col2
FROM table2 OHL
This will get everything that's in OH, but not in OHL.
answered Nov 14 '18 at 17:52
EricEric
1,70711115
answered Nov 14 '18 at 17:52
EricEric
1,70711115
answered Nov 14 '18 at 17:52
EricEric
1,70711115
answered Nov 14 '18 at 17:52
EricEric
1,70711115
1,70711115
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53305995%2fms-sql-not-in-table%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Which dbms is this???
– Eric
Nov 14 '18 at 17:47
Is says "MS SQL" in the title, so I guess SQL Server.
– NicVerAZ
Nov 14 '18 at 17:49