Query in Sql Server

Hi,

SELECT * FROM TABLEA A WHERE NOT EXISTS (SELECT * FROM TABLEB WHERE ID = A.ID)

SELECT DISTINCT ID FROM A WHERE ID NOT IN (SELECT ID FROM B);

SELECT DISTINCT A.ID

FROM A

LEFT OUTER JOIN B

ON A.ID = B.ID

WHERE B.ID IS NULL

SELECT *

FROM A

WHERE ID NOT IN

(

SELECT DISTINCT ID

FROM B

)

GROUP BY ID

HAVING COUNT(*) > 1;

https://www.simple-talk.com/sql/performance/the-except-and-intersect-operators-in-sql-server/

Please try this ,

;WITH userCTE(ID,NAME) AS

(

select t1.ID,t1.Name from table_1 t1

inner join Table_2 t2

on t1.id=t2.userid

)

select * from Table_1 where id not in (select distinct ID from userCTE)

Hope this will help.

Abhishek

Hi

if u used primary key and forigen key u can use inner left joins

refer this query

SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
FROM Orders
INNER JOIN Customers
ON Orders.CustomerID=Customers.CustomerID;

or simply u can type select * from tabel1