lampretard
Sunday, November 13, 2016
SQL select where join not existed; Select where can't join
SELECT
t1
.
ID
FROM
Table1 t1
LEFT
JOIN
Table2 t2
ON
t1
.
ID
=
t2
.
ID
WHERE
t2
.
ID
IS
NULL
source:
http://stackoverflow.com/a/4076157/1767461
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment