Last post May 07, 2018 07:38 PM by ryanbesko
May 07, 2018 07:13 PM|RichardLaw|LINK
I'd like to create a VIEW (SQL) which first selects all the rows in table 1, then if the ID in table 1 matches the ID in table 2, remove it from the results shown in the VIEW.
For example, if table 1 have ID's 1 - 5, and table 2 had the ID's 2 and 3, the VIEW would show ID's 1,4,5
I really hope that makes sense!
Thanks as always
May 07, 2018 07:38 PM|ryanbesko|LINK
FROM Table1 as t1
t1.Id NOT IN (SELECT t2.Id FROM Table2 AS t2)